How to change column name dynamically and assign corresponing value

One Star

How to change column name dynamically and assign corresponing value

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
Sixteen Stars

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

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.
Highlighted
One Star

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

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 requirementSmiley Happy
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...

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.