https://community.qlik.com/t5/Talend-Studio/tPivotToColumnsDelimited-pivot-two-column-in-one-file/m-p/2271391#M49009 Hi Master, <BR />I need to pivot two column, SIZE_SHELF and&nbsp; POSISI_SIKU from a file below : <BR />inputfile <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBZd.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153878i1E46FA88B2A2DABF/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBZd.png" alt="0683p000009MBZd.png" /></span> <BR />The result have to be like this : <BR />outputfile <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBZi.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135420i80BB31AE57543D51/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBZi.png" alt="0683p000009MBZi.png" /></span> <BR />Can i use tPivotToColumnsDelimited to do this? As i know tPivotToColumnsDelimited only pivot one column. <BR />What i do now is split the input file (column SIZE_SHELF and&nbsp; POSISI_SIKU)&nbsp; into two separate file, use tPivotToColumnsDelimited&nbsp; 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. <BR />Is there any better idea? <BR />Thank you and best regards, Sat, 16 Nov 2024 11:03:13 GMT orawajar 2024-11-16T11:03:13Z https://community.qlik.com/t5/Talend-Studio/tPivotToColumnsDelimited-pivot-two-column-in-one-file/m-p/2271391#M49009 Hi Master, <BR />I need to pivot two column, SIZE_SHELF and&nbsp; POSISI_SIKU from a file below : <BR />inputfile <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBZd.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153878i1E46FA88B2A2DABF/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBZd.png" alt="0683p000009MBZd.png" /></span> <BR />The result have to be like this : <BR />outputfile <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBZi.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135420i80BB31AE57543D51/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBZi.png" alt="0683p000009MBZi.png" /></span> <BR />Can i use tPivotToColumnsDelimited to do this? As i know tPivotToColumnsDelimited only pivot one column. <BR />What i do now is split the input file (column SIZE_SHELF and&nbsp; POSISI_SIKU)&nbsp; into two separate file, use tPivotToColumnsDelimited&nbsp; 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. <BR />Is there any better idea? <BR />Thank you and best regards, Sat, 16 Nov 2024 11:03:13 GMT https://community.qlik.com/t5/Talend-Studio/tPivotToColumnsDelimited-pivot-two-column-in-one-file/m-p/2271391#M49009 orawajar 2024-11-16T11:03:13Z https://community.qlik.com/t5/Talend-Studio/tPivotToColumnsDelimited-pivot-two-column-in-one-file/m-p/2271392#M49010 Hi&nbsp; <BR />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. <BR />Best regards <BR />Shong Mon, 28 Sep 2015 10:53:46 GMT https://community.qlik.com/t5/Talend-Studio/tPivotToColumnsDelimited-pivot-two-column-in-one-file/m-p/2271392#M49010 Anonymous 2015-09-28T10:53:46Z