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.)
the output I want is the same as I see in Excel because then I can access each as a field in one row.
However the output I get has blank cells in it.
I don't know how to get rid of the blank cells.
Here are the settings for the tPivotToColumnsDelimited
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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Test drive Talend's enterprise products.