topic How to convert columns to rows in load script? in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-columns-to-rows-in-load-script/m-p/1618889#M734019 <P>Hi All.<BR /><BR />Please, need your advice how I can convert columns to rows using load script from this view</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>User</TD><TD>2019-Jan</TD><TD>2019-Feb</TD></TR><TR><TD>User 1</TD><TD>2,708</TD><TD>3,009</TD></TR><TR><TD>User 2</TD><TD>903</TD><TD>1,003</TD></TR><TR><TD>User 3</TD><TD>501</TD><TD>557</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>To this view</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>User</TD><TD>Date</TD><TD>Sum</TD></TR><TR><TD>User 1</TD><TD>2019-Jan</TD><TD>2,708</TD></TR><TR><TD>User 1</TD><TD>2019-Feb</TD><TD>3,009</TD></TR><TR><TD>User 2</TD><TD>2019-Jan</TD><TD>903</TD></TR><TR><TD>User 2</TD><TD>2019-Feb</TD><TD>1,003</TD></TR><TR><TD>User 3</TD><TD>2019-Jan</TD><TD>501</TD></TR><TR><TD>User 3</TD><TD>2019-Feb</TD><TD>557</TD></TR></TBODY></TABLE><P><BR /><BR /></P> Sat, 16 Nov 2024 02:35:38 GMT Peony 2024-11-16T02:35:38Z How to convert columns to rows in load script? https://community.qlik.com/t5/QlikView/How-to-convert-columns-to-rows-in-load-script/m-p/1618889#M734019 <P>Hi All.<BR /><BR />Please, need your advice how I can convert columns to rows using load script from this view</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>User</TD><TD>2019-Jan</TD><TD>2019-Feb</TD></TR><TR><TD>User 1</TD><TD>2,708</TD><TD>3,009</TD></TR><TR><TD>User 2</TD><TD>903</TD><TD>1,003</TD></TR><TR><TD>User 3</TD><TD>501</TD><TD>557</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>To this view</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>User</TD><TD>Date</TD><TD>Sum</TD></TR><TR><TD>User 1</TD><TD>2019-Jan</TD><TD>2,708</TD></TR><TR><TD>User 1</TD><TD>2019-Feb</TD><TD>3,009</TD></TR><TR><TD>User 2</TD><TD>2019-Jan</TD><TD>903</TD></TR><TR><TD>User 2</TD><TD>2019-Feb</TD><TD>1,003</TD></TR><TR><TD>User 3</TD><TD>2019-Jan</TD><TD>501</TD></TR><TR><TD>User 3</TD><TD>2019-Feb</TD><TD>557</TD></TR></TBODY></TABLE><P><BR /><BR /></P> Sat, 16 Nov 2024 02:35:38 GMT https://community.qlik.com/t5/QlikView/How-to-convert-columns-to-rows-in-load-script/m-p/1618889#M734019 Peony 2024-11-16T02:35:38Z Re: How to convert columns to rows in load script? https://community.qlik.com/t5/QlikView/How-to-convert-columns-to-rows-in-load-script/m-p/1618903#M734020 <P>Use cross table</P><P>CrossTable(Date,Value,1)<BR />LOAD<BR />User,<BR />"2019-Jan",<BR />"2019-Feb"<BR />FROM [lib://Downloads/New Microsoft Excel Worksheet (3).xlsx]<BR />(ooxml, embedded labels, table is Sheet2);</P><P>&nbsp;</P><P>check below</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083</A></P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083</A></P> Fri, 30 Aug 2019 14:59:13 GMT https://community.qlik.com/t5/QlikView/How-to-convert-columns-to-rows-in-load-script/m-p/1618903#M734020 dplr-rn 2019-08-30T14:59:13Z Re: How to convert columns to rows in load script? https://community.qlik.com/t5/QlikView/How-to-convert-columns-to-rows-in-load-script/m-p/1618918#M734021 <P>Perfect!<BR /><BR />Thank You much!</P> Fri, 30 Aug 2019 15:24:11 GMT https://community.qlik.com/t5/QlikView/How-to-convert-columns-to-rows-in-load-script/m-p/1618918#M734021 Peony 2019-08-30T15:24:11Z