topic Re: Convert columns to rows or rows to columns ... in Talend Studio

Convert columns to rows or rows to columns ...

Anonymous — Wed, 19 Jun 2019 16:47:49 GMT

I have array

type	Content
1	toto
2	titre1
1	toto
2	12345678
1	toto
2	fdt12345678
3	fdt.pdf
1	toto
2	fdt
3	fdt12345678.pdf

and I want to convert it into

1	2	3
toto	titre1
toto	12345678
toto	fdt12345678	fdt.pdf
toto	fdt	fdt12345678.pdf

Any Idea ?

I am still in Talend version 5.6 ...

Thank you for your help.

Re: Convert columns to rows or rows to columns ...

Anonymous — Wed, 19 Jun 2019 20:33:06 GMT

Hi Damien,

Please follow the below job design to get your requirement.

Remeber to put the same delimiter and file name for the columns from tPivotToColumnsDelimited to the next tFileInputDelimited.

Thanks and Regards,

Subhadip

Re: Convert columns to rows or rows to columns ...

Anonymous — Thu, 20 Jun 2019 07:56:55 GMT

followed https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/9HBFF9ml06PWtPoPiKa7KA

with

id	question	answer
0	1	toto
0	2	titre1
1	1	toto
1	2	12345678
2	1	toto
2	2	fdt12345678
2	3	fdt.pdf
3	1	toto
3	2	fdt
3	3	fdt12345678.pdf

And the result is

id	1	2	3
3	toto	fdt	fdt12345678.pdf

I only have the last record !!!

Re: Convert columns to rows or rows to columns ...

Anonymous — Thu, 20 Jun 2019 09:39:26 GMT

Bonjour and thank you for your help. Can you detail what you have in the tPivotToColumnsDelimited ... I tried to follow the process described (see link from Talend web site) but I only have the "last" record ... as in the exemple from Talend, they have all lines.
regards
Damien

Re: Convert columns to rows or rows to columns ...

Anonymous — Thu, 20 Jun 2019 15:14:43 GMT

Hi Damien,

Please follow the screenshot as provided, with the proper columns in proper places..

Also please follow the job flow.