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
|9||GNY||LEADER DIREC, INC||GX||CX|
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables