How to transform multiple values from a reference file?

[Anonymous]

Hi,

I'm a new developer in Talend, I have this file with different reference values between systems:

How can I transforme (or translate) the values between systems depending on values from the input message?

For exemple, if I have a message from SystemA and I need to send it to SystemB :

Input message: 

Id	Color	Code
1	Blue	Z001

My output message must be:

Id	Color	Code
1	B	Z-1001

Our objective is to reuse the reference file in another jobs(messages from SystemA to SystemC or SystemB to SystemA, etc) and like you can see, the input message it can have more that just one column to transform (or translate).

I tried tMap, with only one column it works but with 2 columns it's not clear for me, maybe I have to link a second lookup to the tMap?

Thank you so much!

[Anonymous]

Hello,

Have you tried to use a second tMap in your workflow?

Best regards

Sabrina