I am importing data from cvs file.
The data is coded. The data comes from ambulance runs.
There is a lookup table with the followiing
Rig lookup table
CityCode City EmsCode Rig
numb txt numb txt type
2082 PGH 17221 Eng 16 value
in the main CSV file are the following fields
rig1 17221 imported as text but the data dictionary says they are numbers
Ok on import I want to change the numbers to txt designations.
I have tried setting the rig field to text and then set up a lookup on import with Rig Lookup table
I have tried setting the rig field to numeric and then set up a lookup on import Rig Lookup table
It just show the rig1 code 17221, it is like nothing is executing
Thanks in advance, I have been on this site and google for hours trying to figure this out.