Order tMap columns thanks to an external file

[Anonymous]

Hello Talend community,

Here is my problem, I want to affect each input columns from my input file to each corresponding levels in output. The problem is that I want to do that using an external file into which each levels is affected to a column name.

I attached an example of a parameter file.

I also attached a screen shot of the result I would like to get, I tried to set a context "L1" = "row1.COL2" but it is not working.

How can I order the input columns thanks to an external file ?

Many thanks for your help,

Regards;

Thomas

[Anonymous]

Hello,

What's actual result are you getting when you map your input columns to each corresponding levels output in tMap?

Best regards

Sabrina

[Anonymous]

Hello,

Or are you looking for talend dynamic schema feature?

https://www.talend.com/blog/2019/10/31/magically-shuffle-columns-talend-dynamic-schema/?_ga=2.147478... 

Best regards

Sabrina