How to do a crosswalk for flat files?

[Anonymous]

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_TYPE	DOC_NUM	DESC	OLD_CST_CODE	NEW_CST_ADD_CODE	NEW_CST_NAME	Line Number
HEADER	QA_001	header desc	5
LINE		line desc				1

crosswalk data

OLD_CST_CODE	OLD_ADD_CODE	OLD_CUST NAME	NEW_CST_ADD_CODE	NEW_CST_NAME
5	PAL	MC COM	GX	CX
7	GWDC	WASH AUTHORITY	GX	CX
9	GNY	LEADER DIREC, INC	GX	CX

Thank you

[Anonymous · Accepted solution]

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