topic Creating multiple columns with CrossTable in QlikView https://community.qlik.com/t5/QlikView/Creating-multiple-columns-with-CrossTable/m-p/1756848#M590753 <P>I have a table that I have to transpose every 10 lines, therefore creating 10 columns. Originally it looks like this:</P><TABLE><TBODY><TR><TD>Value</TD><TD>Index</TD></TR><TR><TD>121</TD><TD>1</TD></TR><TR><TD>125</TD><TD>1</TD></TR><TR><TD>1258412</TD><TD>1</TD></TR><TR><TD>14852</TD><TD>1</TD></TR><TR><TD>584125</TD><TD>1</TD></TR><TR><TD>5846</TD><TD>1</TD></TR><TR><TD>98953</TD><TD>1</TD></TR><TR><TD>41265</TD><TD>1</TD></TR><TR><TD>14862</TD><TD>1</TD></TR><TR><TD>247862</TD><TD>1</TD></TR><TR><TD>5896215</TD><TD>2</TD></TR><TR><TD>5265</TD><TD>2</TD></TR><TR><TD>652652</TD><TD>2</TD></TR><TR><TD>6523652</TD><TD>2</TD></TR><TR><TD>6984255</TD><TD>2</TD></TR><TR><TD>65264125</TD><TD>2</TD></TR><TR><TD>36525236</TD><TD>2</TD></TR><TR><TD>25315230</TD><TD>2</TD></TR><TR><TD>6841254</TD><TD>2</TD></TR><TR><TD>14521452</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The index represents the number of the line. As you can see there are only two columns in the table. I tried to create a CrossTable function but I do not understand how to do it and specify that there should be 10 new columns.</P><P>The final result should look like this:&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>index</TD><TD>column 1</TD><TD>column 2</TD><TD>column 3</TD><TD>column 4</TD><TD>column 5</TD><TD>column 6</TD><TD>column 7</TD><TD>column 8</TD><TD>column 9</TD><TD>column 10</TD></TR><TR><TD>1</TD><TD>121</TD><TD>125</TD><TD>1258412</TD><TD>14852</TD><TD>584125</TD><TD>5846</TD><TD>98953</TD><TD>41265</TD><TD>14862</TD><TD>247862</TD></TR><TR><TD>2</TD><TD>5896215</TD><TD>5265</TD><TD>652652</TD><TD>6523652</TD><TD>6984255</TD><TD>65264125</TD><TD>36525236</TD><TD>25315230</TD><TD>6841254</TD><TD>14521452</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can someone please, help me write the script?&nbsp;</P> Sat, 16 Nov 2024 17:54:28 GMT ggerotto 2024-11-16T17:54:28Z Creating multiple columns with CrossTable https://community.qlik.com/t5/QlikView/Creating-multiple-columns-with-CrossTable/m-p/1756848#M590753 <P>I have a table that I have to transpose every 10 lines, therefore creating 10 columns. Originally it looks like this:</P><TABLE><TBODY><TR><TD>Value</TD><TD>Index</TD></TR><TR><TD>121</TD><TD>1</TD></TR><TR><TD>125</TD><TD>1</TD></TR><TR><TD>1258412</TD><TD>1</TD></TR><TR><TD>14852</TD><TD>1</TD></TR><TR><TD>584125</TD><TD>1</TD></TR><TR><TD>5846</TD><TD>1</TD></TR><TR><TD>98953</TD><TD>1</TD></TR><TR><TD>41265</TD><TD>1</TD></TR><TR><TD>14862</TD><TD>1</TD></TR><TR><TD>247862</TD><TD>1</TD></TR><TR><TD>5896215</TD><TD>2</TD></TR><TR><TD>5265</TD><TD>2</TD></TR><TR><TD>652652</TD><TD>2</TD></TR><TR><TD>6523652</TD><TD>2</TD></TR><TR><TD>6984255</TD><TD>2</TD></TR><TR><TD>65264125</TD><TD>2</TD></TR><TR><TD>36525236</TD><TD>2</TD></TR><TR><TD>25315230</TD><TD>2</TD></TR><TR><TD>6841254</TD><TD>2</TD></TR><TR><TD>14521452</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The index represents the number of the line. As you can see there are only two columns in the table. I tried to create a CrossTable function but I do not understand how to do it and specify that there should be 10 new columns.</P><P>The final result should look like this:&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>index</TD><TD>column 1</TD><TD>column 2</TD><TD>column 3</TD><TD>column 4</TD><TD>column 5</TD><TD>column 6</TD><TD>column 7</TD><TD>column 8</TD><TD>column 9</TD><TD>column 10</TD></TR><TR><TD>1</TD><TD>121</TD><TD>125</TD><TD>1258412</TD><TD>14852</TD><TD>584125</TD><TD>5846</TD><TD>98953</TD><TD>41265</TD><TD>14862</TD><TD>247862</TD></TR><TR><TD>2</TD><TD>5896215</TD><TD>5265</TD><TD>652652</TD><TD>6523652</TD><TD>6984255</TD><TD>65264125</TD><TD>36525236</TD><TD>25315230</TD><TD>6841254</TD><TD>14521452</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can someone please, help me write the script?&nbsp;</P> Sat, 16 Nov 2024 17:54:28 GMT https://community.qlik.com/t5/QlikView/Creating-multiple-columns-with-CrossTable/m-p/1756848#M590753 ggerotto 2024-11-16T17:54:28Z Re: Creating multiple columns with CrossTable https://community.qlik.com/t5/QlikView/Creating-multiple-columns-with-CrossTable/m-p/1756889#M590754 <P>It's actually a Generic Load problem, not a CrossTable Load. This script will do the trick with your sample data.</P><P class="p1"><FONT face="courier new,courier"><SPAN class="s1">Data:<BR /></SPAN><SPAN class="s2">Generic</SPAN><SPAN class="s1"><BR /></SPAN><SPAN class="s2">LOAD</SPAN><SPAN class="s1"><BR /></SPAN>&nbsp; Index<SPAN class="s1">,<BR />&nbsp; 'Column ' &amp; </SPAN><SPAN class="s2">AutoNumber</SPAN><SPAN class="s1">(</SPAN><SPAN class="s2">RecNo</SPAN><SPAN class="s1">(), </SPAN>Index<SPAN class="s1">),<BR /></SPAN>&nbsp; Value<SPAN class="s1"> <SPAN class="Apple-converted-space">&nbsp; &nbsp; &nbsp;</SPAN><BR /></SPAN><SPAN class="s2">FROM</SPAN><SPAN class="s1"><BR /></SPAN>[<A href="https://community.qlik.com/t5/QlikView-Scripting/Creating-multiple-columns-with-CrossTable/td-p/1756848" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/Creating-multiple-columns-with-CrossTable/td-p/1756848</A>]<SPAN class="s1"><BR />(</SPAN><SPAN class="s2">html</SPAN><SPAN class="s1">, </SPAN><SPAN class="s2">utf8</SPAN><SPAN class="s1">, </SPAN><SPAN class="s2">UserAgent</SPAN> <SPAN class="s2">is</SPAN><SPAN class="s1"> 'Mozilla/5.0', </SPAN><SPAN class="s2">embedded</SPAN> <SPAN class="s2">labels</SPAN><SPAN class="s1">, </SPAN><SPAN class="s2">table</SPAN> <SPAN class="s2">is</SPAN><SPAN class="s1"> @1); </SPAN></FONT></P><P class="p1">See:&nbsp;<A href="https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/" target="_blank">https://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/</A></P><P class="p1">-Rob<BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A><BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A></P> Wed, 28 Oct 2020 23:38:49 GMT https://community.qlik.com/t5/QlikView/Creating-multiple-columns-with-CrossTable/m-p/1756889#M590754 rwunderlich 2020-10-28T23:38:49Z Re: Creating multiple columns with CrossTable https://community.qlik.com/t5/QlikView/Creating-multiple-columns-with-CrossTable/m-p/1756890#M590755 <P>Thank you!</P> Wed, 28 Oct 2020 23:47:47 GMT https://community.qlik.com/t5/QlikView/Creating-multiple-columns-with-CrossTable/m-p/1756890#M590755 ggerotto 2020-10-28T23:47:47Z