From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

Order tmap columns with context variables

Highlighted
One Star

Order tmap columns with context variables

Dear Talend community,

 

I'm trying to order tMap columns using an external file wich contain the correct order (see the screen in attachment).

 

For example I would like to put the COL2 in the Level1, the COL1 in the Level2 and so on... (see the second screenshot) following the mapping in the external file.

 

Do you thing that it is possible ? If so how can I do that ? I tried to use a context like Level1 = "row1.COL2" and put it into the Tmap mapping but it's not working...

 

Thanks for your help !

 

Thomas

Highlighted
One Star

Re: Order tmap columns with context variables

here is my second screenshot, sorry !

Highlighted
Sixteen Stars
Sixteen Stars

Re: Order tmap columns with context variables

Highlighted
Four Stars

Re: Order tmap columns with context variables

very useful thank you !

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog