Forum Discussion
Date table join error during refresh: The key didn't match any rows in the table
I've added a new table to my datamodel which links to a simple excel file that lists dates from 2/1/20 to 7/1/20 and another column with data. I've joined this table to my date table in my data model...
From date to table make it many to one and try load again. or try once by disconnecting the join and once data is loaded join again. It should take correct join
Abduvali
Skilled Sharer
Skilled SharerHi Anonymous,
Not sure about your dates format in SIOP table =o?
SIOP date format is dispalys 05/01/20? and Dates table has it as 01/01/2000
Just make sure your dates are in identical format and then join, it should work as guys mentioned already.
Regards
Abduvali