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,
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