Order tmap columns with context variables

[thomas77380]

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

[thomas77380]

here is my second screenshot, sorry !

example.PNG

[TRF]

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

[Anonymous]

very useful thank you !