topic Re: Rows to Columns!!!! in Talend Studio

Rows to Columns!!!!

ankit7359 — Wed, 26 Dec 2018 10:44:16 GMT

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

Re: Rows to Columns!!!!

akumar2301 — Wed, 26 Dec 2018 11:24:20 GMT

tPivotToColumnsDelimited

Re: Rows to Columns!!!!

ankit7359 — Wed, 26 Dec 2018 11:29:56 GMT

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.

Re: Rows to Columns!!!!

Ganshyam — Wed, 26 Dec 2018 11:38:27 GMT

Hello,

Some workaround , but might solve your purpose.

Regard

Ganshyam

Re: Rows to Columns!!!!

ankit7359 — Wed, 26 Dec 2018 12:23:21 GMT

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

Re: Rows to Columns!!!!

Ganshyam — Wed, 26 Dec 2018 13:03:41 GMT

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

Re: Rows to Columns!!!!

ankit7359 — Wed, 26 Dec 2018 13:20:40 GMT

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

Re: Rows to Columns!!!!

akumar2301 — Wed, 26 Dec 2018 13:58:53 GMT

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-p/44412

Re: Rows to Columns!!!!

Ganshyam — Wed, 26 Dec 2018 14:47:08 GMT

Hello ,

Below are the logic used in tmap and tdenormalize component.

Please check it and make necessary changes.

Regards

Ganshyam

Re: Rows to Columns!!!!

ankit7359 — Wed, 26 Dec 2018 14:55:59 GMT

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

Re: Rows to Columns!!!!

ankit7359 — Wed, 26 Dec 2018 15:02:19 GMT

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

Re: Rows to Columns!!!!

Ganshyam — Thu, 27 Dec 2018 09:37:06 GMT

Hello,

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

Please make changes accordingly

Regards

Ganshyam

tdenormalize.zip

Re: Rows to Columns!!!!

dipanjan93 — Thu, 27 Dec 2018 12:32:32 GMT

Apply the below logic - JobtFixedFlowInputtDenormalizetMaptNormalizeOutput