jcondle

How to use lookup when importing data from a csv file.

Discussion created by jcondle on Jan 19, 2016
Latest reply on Jan 19, 2016 by jcondle

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

rig2 18221

rig3

rig4

 

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.

 

Joe

Outcomes