https://community.qlik.com/t5/QlikView/Switch-table-column/m-p/1588177#M738237 <P>Hello!</P><P>Following table:</P><TABLE border="1"><TBODY><TR><TD>order number</TD><TD>sub</TD><TD>weight</TD></TR><TR><TD>1234567</TD><TD>&nbsp;</TD><TD>50</TD></TR><TR><TD>1234567</TD><TD>1</TD><TD>70</TD></TR><TR><TD>1234567</TD><TD>2</TD><TD>90</TD></TR><TR><TD>9876543</TD><TD>&nbsp;</TD><TD>30</TD></TR><TR><TD>9876543</TD><TD>1</TD><TD>50</TD></TR><TR><TD>9876543</TD><TD>2</TD><TD>60</TD></TR></TBODY></TABLE><P><BR />Now would like to represent the <STRONG>weight</STRONG> of <STRONG>oder numer&nbsp; &amp; sub</STRONG>&nbsp; in one line.</P><TABLE border="1"><TBODY><TR><TD>ornder number</TD><TD>weight order number</TD><TD>weight sub 1</TD><TD>weight sub 2</TD></TR><TR><TD>1234567</TD><TD>50</TD><TD>70</TD><TD>90</TD></TR><TR><TD>9876543</TD><TD>30</TD><TD>50</TD><TD>60</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you for your help!</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT Keyuser 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Switch-table-column/m-p/1588177#M738237 <P>Hello!</P><P>Following table:</P><TABLE border="1"><TBODY><TR><TD>order number</TD><TD>sub</TD><TD>weight</TD></TR><TR><TD>1234567</TD><TD>&nbsp;</TD><TD>50</TD></TR><TR><TD>1234567</TD><TD>1</TD><TD>70</TD></TR><TR><TD>1234567</TD><TD>2</TD><TD>90</TD></TR><TR><TD>9876543</TD><TD>&nbsp;</TD><TD>30</TD></TR><TR><TD>9876543</TD><TD>1</TD><TD>50</TD></TR><TR><TD>9876543</TD><TD>2</TD><TD>60</TD></TR></TBODY></TABLE><P><BR />Now would like to represent the <STRONG>weight</STRONG> of <STRONG>oder numer&nbsp; &amp; sub</STRONG>&nbsp; in one line.</P><TABLE border="1"><TBODY><TR><TD>ornder number</TD><TD>weight order number</TD><TD>weight sub 1</TD><TD>weight sub 2</TD></TR><TR><TD>1234567</TD><TD>50</TD><TD>70</TD><TD>90</TD></TR><TR><TD>9876543</TD><TD>30</TD><TD>50</TD><TD>60</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you for your help!</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Switch-table-column/m-p/1588177#M738237 Keyuser 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Switch-table-column/m-p/1588193#M738238 Use generic Load<BR />try below script<BR /><BR />Temp:<BR />Load * Inline [<BR />order_number, sub, weight<BR />1234567, 0 , 50<BR />1234567, 1, 70<BR />1234567, 2, 90<BR />9876543, 0, 30<BR />9876543, 1, 50<BR />9876543, 2, 60<BR />];<BR /><BR /><BR />test2:<BR />Generic Load * Resident Temp;<BR /><BR />drop Table Temp;<BR /><BR />Regards,<BR />Prashant Sangle Tue, 04 Jun 2019 13:25:09 GMT https://community.qlik.com/t5/QlikView/Switch-table-column/m-p/1588193#M738238 PrashantSangle 2019-06-04T13:25:09Z