Five Stars

How to do a crosswalk for flat files?

I would like to do a crosswalk for a data that needs a transformation from excel sheet into a csv, here is the data that need to be transformed, I would like the NEW_CST_ADD_CODE and  NEW_CST_NAME to come from the crosswalk data provided below based on OLD_CST_CODE being the key,

 

I would appreciate any help on this. I provided the data to be transformed and the crosswalk data.

 

Data to transform

 

REC_TYPEDOC_NUMDESCOLD_CST_CODENEW_CST_ADD_CODENEW_CST_NAMELine Number
HEADERQA_001header desc5   
LINE line desc   1

 

crosswalk data

OLD_CST_CODEOLD_ADD_CODEOLD_CUST NAMENEW_CST_ADD_CODENEW_CST_NAME
5PALMC COMGX CX
7GWDCWASH AUTHORITYGX CX
9GNYLEADER DIREC, INCGX CX

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: How to do a crosswalk for flat files?

Use a tMap and join on OLD_CST_CODE. Set your source data as your Main and the CrossWalk data as your Lookup.

Rilhia Solutions
1 REPLY
Twelve Stars

Re: How to do a crosswalk for flat files?

Use a tMap and join on OLD_CST_CODE. Set your source data as your Main and the CrossWalk data as your Lookup.

Rilhia Solutions