This means 1 of 2 things
1) You imported the data in the wrong order. In this case the data you are importing expects the other records to exist already so the order you import the records into matter
or
2) It cannot find the GUID of the record. So its possible you DID import the other records, but when they got imported, they got new GUIDS from the Insert, different than what was in the file.
Since THIS data is mapped based on the value of the GUID of the other table from the Excel file, when the GUID changed it won't find it
Table A Row 1 ID (GUID) in Excel = 1234567
Table B Row 1 has a Lookup to Table A, pointing to Row 1, and in the Excel has GUID 1234567 as the lookup value
But either Table A is NOT there yet (import it first)
or
When you imported, RoW got a new GUID and is now 567890 instead of 1234567
So when Table B Row 1, tries to insert, the lookup value 1234567 is not valid.
What order did you import the data?
Are there specific instructions on the order of how to import them or to create a specific Mapping Selection so that it KEEPS the GUID from the File (which is possible), so that when you insert Table B, data it will have the right GUID.
and they will for sure help you.
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
