topic How to do a crosswalk for flat files? in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-do-a-crosswalk-for-flat-files/m-p/2321367#M91403 <P>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&nbsp;<SPAN>NEW_CST_ADD_CODE and &nbsp;NEW_CST_NAME to come from the crosswalk data provided below based on OLD_CST_CODE being the key,</SPAN></P> <P>&nbsp;</P> <P>I would appreciate any help on this. I provided the data to be transformed and the crosswalk data.</P> <P>&nbsp;</P> <P>Data to transform</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD>REC_TYPE</TD> <TD>DOC_NUM</TD> <TD>DESC</TD> <TD>OLD_CST_CODE</TD> <TD>NEW_CST_ADD_CODE</TD> <TD>NEW_CST_NAME</TD> <TD>Line Number</TD> </TR> <TR> <TD>HEADER</TD> <TD>QA_001</TD> <TD>header desc</TD> <TD>5</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>LINE</TD> <TD>&nbsp;</TD> <TD>line desc</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>crosswalk data</P> <TABLE> <TBODY> <TR> <TD>OLD_CST_CODE</TD> <TD>OLD_ADD_CODE</TD> <TD>OLD_CUST NAME</TD> <TD>NEW_CST_ADD_CODE</TD> <TD>NEW_CST_NAME</TD> </TR> <TR> <TD>5</TD> <TD>PAL</TD> <TD>MC COM</TD> <TD>GX</TD> <TD>&nbsp;CX</TD> </TR> <TR> <TD>7</TD> <TD>GWDC</TD> <TD>WASH AUTHORITY</TD> <TD>GX</TD> <TD>&nbsp;CX</TD> </TR> <TR> <TD>9</TD> <TD>GNY</TD> <TD>LEADER DIREC, INC</TD> <TD>GX</TD> <TD>&nbsp;CX</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank you</P> Mon, 10 Jul 2017 16:26:56 GMT Anonymous 2017-07-10T16:26:56Z How to do a crosswalk for flat files? https://community.qlik.com/t5/Talend-Studio/How-to-do-a-crosswalk-for-flat-files/m-p/2321367#M91403 <P>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&nbsp;<SPAN>NEW_CST_ADD_CODE and &nbsp;NEW_CST_NAME to come from the crosswalk data provided below based on OLD_CST_CODE being the key,</SPAN></P> <P>&nbsp;</P> <P>I would appreciate any help on this. I provided the data to be transformed and the crosswalk data.</P> <P>&nbsp;</P> <P>Data to transform</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD>REC_TYPE</TD> <TD>DOC_NUM</TD> <TD>DESC</TD> <TD>OLD_CST_CODE</TD> <TD>NEW_CST_ADD_CODE</TD> <TD>NEW_CST_NAME</TD> <TD>Line Number</TD> </TR> <TR> <TD>HEADER</TD> <TD>QA_001</TD> <TD>header desc</TD> <TD>5</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>LINE</TD> <TD>&nbsp;</TD> <TD>line desc</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>crosswalk data</P> <TABLE> <TBODY> <TR> <TD>OLD_CST_CODE</TD> <TD>OLD_ADD_CODE</TD> <TD>OLD_CUST NAME</TD> <TD>NEW_CST_ADD_CODE</TD> <TD>NEW_CST_NAME</TD> </TR> <TR> <TD>5</TD> <TD>PAL</TD> <TD>MC COM</TD> <TD>GX</TD> <TD>&nbsp;CX</TD> </TR> <TR> <TD>7</TD> <TD>GWDC</TD> <TD>WASH AUTHORITY</TD> <TD>GX</TD> <TD>&nbsp;CX</TD> </TR> <TR> <TD>9</TD> <TD>GNY</TD> <TD>LEADER DIREC, INC</TD> <TD>GX</TD> <TD>&nbsp;CX</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank you</P> Mon, 10 Jul 2017 16:26:56 GMT https://community.qlik.com/t5/Talend-Studio/How-to-do-a-crosswalk-for-flat-files/m-p/2321367#M91403 Anonymous 2017-07-10T16:26:56Z Re: How to do a crosswalk for flat files? https://community.qlik.com/t5/Talend-Studio/How-to-do-a-crosswalk-for-flat-files/m-p/2321368#M91404 <P>Use a tMap and join on OLD_CST_CODE. Set your source data as your Main and the CrossWalk data as your Lookup.</P> Mon, 10 Jul 2017 16:46:04 GMT https://community.qlik.com/t5/Talend-Studio/How-to-do-a-crosswalk-for-flat-files/m-p/2321368#M91404 Anonymous 2017-07-10T16:46:04Z