Import data in a column marked as a foreing key

[Marilou Dallaire]

Hi,

I'm currently importing data from a file into a Simio table. One specific column is marked as a "Foreing Key Property".

Every time that I import my data, every entry in that specific column is marked as an error (see image).

Any idea why this happens and how to fix it? 

Thanks!

[millej6]

UPDATE ON THE PROBLEM:

Trailing spaces in ProdCenterID are ignored when imported from a CSV file but not when imported from SQL view/Stored procedure. The foreign key was created on data with trailing spaces coming from SQL data.

Note: I suspect trailing spaces come from SQL CHAR(N) data format. Data should be converted/cleaned in view/Stored procedure to avoid problems in the model.

Edited July 15 by millej6