Convert columns to rows or rows to columns ...

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi Damien,

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

Also please follow the job flow.