Rows to Columns!!!!

[ankit7359]

Hi All,

Greetings of the Day,

There is a scenario i came across where the rows of a delimited file must be converted as columns.

Here is the input:

Col1
A:100
B:200
C:300

Here is the expected Output:

A | B |C

100|200|300

I have tried by using tDenormalize but it was of no use.

Pls do help.

Thanks,

Ankit

[ankit7359]

Hi @Ganshyam,

i am still not getting the required output.. 

i have checked the logic and i have also implemented the same.. can you pls briefly explain and send few more screeenshots, on this.

Thanks,

AnkitRUN_TAB

[Ganshyam · Accepted solution]

Hello,

Below screenshot for each component and attached is talend job desing (v7.0.1).

Please make changes accordingly

Regards

Ganshyam

tdenormalize.zip

[dipanjan93]

Apply the below logic - JobtFixedFlowInputtDenormalizetMaptNormalizeOutput