I received the data, in the capture, from an excel and imported it into FM.
The data in the excel, i generated and exported from a different FM data base.
I've put the Primary ID in both sets of data. see capture - red...
In the capture, the blue circled data is the same... meaning it represents names... one the full name and the other an abbreviation.
I'm trying to compare the data side by side... so the ones circled in blue are side by side... and i can compare the rates side by side...
or column e in the excel with record 21 in FM.
I can script it, but is there a way to simply manipulate the data in either excel or FM to import it?