How to do a crosswalk for flat files?

Highlighted
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


Accepted Solutions
Community Manager

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.

View solution in original post


All Replies
Community Manager

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.

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog