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