https://community.qlik.com/t5/Talend-Studio/Pivot-Values-to-Columns/m-p/2283492#M57392 Hi <BR />The slow performance is because tPivotToColumnsDelimited needs to load 500K first and calculate the number of columns then. <BR />Is it possible to split 500k files into several files in terms of your logic? <BR />Or I don't think a workaround exists. <BR />Regards, <BR />Pedro Mon, 25 Jun 2012 04:08:11 GMT Anonymous 2012-06-25T04:08:11Z https://community.qlik.com/t5/Talend-Studio/Pivot-Values-to-Columns/m-p/2283491#M57391 i have a structure <BR />id | name | value <BR />1 | name1 | value1 <BR />1 | name2 | value2 <BR />2 | name1 | value1 <BR />2 | name2 | value2 <BR />and I need it in the form <BR />id | name1 | name2 <BR />1 | value1 | value2 <BR />2 | value1 | value2 <BR />the number of name columns to pivot is dynamic. <BR />i have tried using the tPivotToColumnsDelimited component. it is way too slow on a large set, approx 300-800 rec / sec. processing 500k rows is rediculous. anyone have an alternative? using multiple splits/denormalizing would be great if possible. I am still trying to figure out the dynamic column routine somehow. <BR />thanks. Fri, 22 Jun 2012 20:58:33 GMT https://community.qlik.com/t5/Talend-Studio/Pivot-Values-to-Columns/m-p/2283491#M57391 Anonymous 2012-06-22T20:58:33Z https://community.qlik.com/t5/Talend-Studio/Pivot-Values-to-Columns/m-p/2283492#M57392 Hi <BR />The slow performance is because tPivotToColumnsDelimited needs to load 500K first and calculate the number of columns then. <BR />Is it possible to split 500k files into several files in terms of your logic? <BR />Or I don't think a workaround exists. <BR />Regards, <BR />Pedro Mon, 25 Jun 2012 04:08:11 GMT https://community.qlik.com/t5/Talend-Studio/Pivot-Values-to-Columns/m-p/2283492#M57392 Anonymous 2012-06-25T04:08:11Z