Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
orawajar
Contributor III
Contributor III

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
0683p000009MBZd.png
The result have to be like this :
outputfile
0683p000009MBZi.png
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,
Labels (2)
1 Reply
Anonymous
Not applicable

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