How to do a crosswalk for flat files?

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.


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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads