topic Re: Talend Excel Transpose Equivalent Component in Talend Studio

Talend Excel Transpose Equivalent Component

Anonymous — Sat, 16 Nov 2024 12:46:48 GMT

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.

Re: Talend Excel Transpose Equivalent Component

Anonymous — Wed, 27 Jul 2011 11:02:59 GMT

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

Re: Talend Excel Transpose Equivalent Component

Anonymous — Wed, 30 Jan 2019 00:48:53 GMT

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?

Re: Talend Excel Transpose Equivalent Component

akumar2301 — Wed, 30 Jan 2019 06:54:48 GMT

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