Talend Excel Transpose Equivalent Component

[Anonymous]

I have noticed that talend does not have a component that is equivalent to the transpose function in excel.
Please advise whether we have anything of that sort.

[Anonymous]

Hi
You can use tPivotToColumnDelimited component to transform records from column to row.
Best regards
Shong

[Anonymous]

Hi

tPivotToColumnDelimited doesn't seem to work as expected. Maybe I am not using it correctly.

I want to do a simple Transpose - like in Excel only I have to do it in Talend.

Data: (a small selection - and the memory can be up to 255 chars long.)

wassa	memory
deriv	||OBL|MER|SSRTE||
master	||RRL|MMMR|UMNR||
method	||PPRL|EMR|LKNR||

the output I want is the same as I see in Excel because then I can access each as a field in one row.

wassa	deriv	master	method
memory	||OBL|MER|SSRTE||	||RRL|MMMR|UMNR||	||PPRL|EMR|LKNR||

However the output I get has blank cells in it.

wassa	deriv	master	method
deriv	||OBL|MER|SSRTE||
master		||RRL|MMMR|UMNR||
method			||PPRL|EMR|LKNR||

I don't know how to get rid of the blank cells.

Here are the settings for the tPivotToColumnsDelimited

Any ideas?

[akumar2301]

Add id number for each set. and then use the component.

in this case all records will be 1 as all belongs to same row or set.

follow below link

https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/GW_EzpRJPsxxxIbzHtGxjQ