topic Re: Order tmap columns with context variables in Talend Studio

Order tmap columns with context variables

thomas77380 — Sun, 03 Nov 2019 09:42:57 GMT

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

Re: Order tmap columns with context variables

thomas77380 — Sun, 03 Nov 2019 09:43:42 GMT

here is my second screenshot, sorry !

example.PNG

Re: Order tmap columns with context variables

TRF — Sun, 03 Nov 2019 10:54:27 GMT

This link may helps you
https://www.talend.com/blog/2019/10/31/magically-shuffle-columns-talend-dynamic-schema/

Re: Order tmap columns with context variables

Anonymous — Mon, 04 Nov 2019 16:16:42 GMT

very useful thank you !