Talend Excel Transpose Equivalent Component

One Star

Talend Excel Transpose Equivalent Component

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.
Community Manager

Re: Talend Excel Transpose Equivalent Component

Hi
You can use tPivotToColumnDelimited component to transform records from column to row.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Talend Excel Transpose Equivalent Component

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.)

wassamemory
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.

wassaderivmastermethod 
memory||OBL|MER|SSRTE||||RRL|MMMR|UMNR||||PPRL|EMR|LKNR||

 

However the output I get has blank cells in it.

wassaderivmastermethod
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

wassa.JPG

 

Any ideas?

Nine Stars

Re: Talend Excel Transpose Equivalent Component

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 

Regards
Abhishek KUMAR

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads