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
Join us live for a sneak peek!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.