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

[akumar2301]

 tPivotToColumnsDelimited

[ankit7359]

hey @uganesh,

thanks for your reply.. 

but i couldnt get the desired output even then...

by using tpivottocolumnsdelimited..

the below is the output i m getting.. 

Col1;A:100;B:200;C:300
A:100;A:100;;
B:200;;B:200;
C:300;;;C:300

I have also tried a workaround by extracting the delimited fields and then denormalising it but even then i could get it.

Thanks,

Ankit.

[Ganshyam]

Hello,

Some workaround , but might solve your purpose.

Regard

Ganshyam

[ankit7359]

hi @Ganshyam,

Greetings of the day,

As per your workaround can you pls tell me why tmap was used are you trying to write some logic in them ??

Can you pls explain your workaround process breifly??

Thanks,

Ankit

[Ganshyam]

Hello,

Yes, I have written logic in tmap to separate the string using string handling functions.

 Once the string are separated used tdenoramlize component to get the desired output.

Regards

[ankit7359]

Hi @Ganshyam,

Thanks for your reply,

i too have tried your scenario,but i couldnt get the output.. 

Can you pls help me find out where i missed.

Pls refer to the below attached screenshots.

tunite settingstdenormalise settingsTmap settingsJob design

Output

Pls do point out where i have missed.. 

Thanks,

Ankit

[akumar2301]

Hello Ankit ,

Please try once tTranspose . It is a custom component. This might work for you.

https://community.talend.com/t5/Design-and-Development/How-to-transpose-Rows-to-Columns-in-Excel/td-...

[Ganshyam]

Hello ,

Below are the logic used in tmap and tdenormalize component.

Please check it and make necessary changes.

Regards

Ganshyam

[ankit7359]

Hi @uganesh,

i dont think there is tTranspose component as of Talend 6.3.

Though it is a custom component, i dont think it exists.

Thanks,

Ankit