tPivotToColumnsDelimited pivot two column in one file?

Four Stars

tPivotToColumnsDelimited pivot two column in one file?

Hi Master,
I need to pivot two column, SIZE_SHELF and  POSISI_SIKU from a file below :
inputfile

The result have to be like this :
outputfile

Can i use tPivotToColumnsDelimited to do this? As i know tPivotToColumnsDelimited only pivot one column.
What i do now is split the input file (column SIZE_SHELF and  POSISI_SIKU)  into two separate file, use tPivotToColumnsDelimited  to each file, and re-join the files. But it makes my job run so slow because i need to process thousands of input files.
Is there any better idea?
Thank you and best regards,
Community Manager

Re: tPivotToColumnsDelimited pivot two column in one file?

Hi 
You can only pivot one column at a time with tPivotToColumnsDelimited. You can try also tDenormalized+tExtractDelimtedFields instead of using tPivotToColumnsDelimited to write the data to file.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER 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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now