topic Re: Order tMap columns thanks to an external file in Talend Studio

Order tMap columns thanks to an external file

Anonymous — Sat, 02 Nov 2019 14:19:42 GMT

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

Re: Order tMap columns thanks to an external file

Anonymous — Mon, 04 Nov 2019 08:24:22 GMT

Hello,

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

Best regards

Sabrina

Re: Order tMap columns thanks to an external file

Anonymous — Mon, 04 Nov 2019 08:40:57 GMT

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.147478327.1235741883.1572834353-1586903423.1567667931

Best regards

Sabrina