topic How to change column name dynamically and assign corresponing value in Talend Studio

How to change column name dynamically and assign corresponing value

Anonymous — Sat, 12 Dec 2015 07:03:26 GMT

I have below scenario...
Input-
id field1 field2
1   abc      A1
1   pqr      B1
1   xyz      C1
Output-
for first row -
id   A1
1    abc
for second row-
id   B1
1    pqr
for third row-
id   C1
1    xyz
Here,
A1,B1,C1 are values in input file. but, in output we want it as a column name(should change dynamically)
and also I am assigning corresponding values from field1 to A1,B1,C1
Regards,
Kiran

Re: How to change column name dynamically and assign corresponing value

Anonymous — Sat, 12 Dec 2015 12:52:37 GMT

This isn't exactly what you want, but given what you have said I think that a solution like this will work for you. I have written a tutorial on writing a job which can deal with a dynamic column order. You can find it here.

Re: How to change column name dynamically and assign corresponing value

Anonymous — Sun, 13 Dec 2015 14:42:42 GMT

Thanks Rilhia for your response...
Your Blog is very helpful. but I want to change/set column name dynamically for each row. don't get wondered...It's my requirement
Actually I could achieve this using tPivotToColumnsDelimited component. but I want to change the column name on the fly.
If you have any clue please suggest...