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?

Eleven 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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads