https://community.qlik.com/t5/App-Development/Transform-table-in-script/m-p/1831370#M68548 <P>Found the answer.</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470</A></P> Thu, 26 Aug 2021 11:56:13 GMT Jonathan_Alm 2021-08-26T11:56:13Z https://community.qlik.com/t5/App-Development/Transform-table-in-script/m-p/1831352#M68544 <P>Hi,</P><P>I have a table that looks like this:</P><TABLE border="1"><TBODY><TR><TD><STRONG>Name</STRONG></TD><TD><STRONG>Content</STRONG></TD><TD><STRONG>Key</STRONG></TD></TR><TR><TD>Firstname</TD><TD>John</TD><TD>1</TD></TR><TR><TD>Lastname</TD><TD>Andersson</TD><TD>1</TD></TR><TR><TD>Age</TD><TD>30</TD><TD>1</TD></TR><TR><TD>Firstname</TD><TD>Carl</TD><TD>2</TD></TR><TR><TD>Lastname</TD><TD>Johnsson</TD><TD>2</TD></TR><TR><TD>Age</TD><TD>40</TD><TD>2</TD></TR><TR><TD>Firstname</TD><TD>Lisa</TD><TD>3</TD></TR><TR><TD>Lastname</TD><TD>Snow</TD><TD>3</TD></TR><TR><TD>Age</TD><TD>50</TD><TD>3</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to create a table that looks like this:</P><TABLE border="1"><TBODY><TR><TD>Key</TD><TD>Firstname</TD><TD>Lastname</TD><TD>Age</TD></TR><TR><TD>1</TD><TD>John</TD><TD>Andersson</TD><TD>30</TD></TR><TR><TD>2</TD><TD>Carl</TD><TD>Johnsson</TD><TD>40</TD></TR><TR><TD>3</TD><TD>Lisa</TD><TD>Snow</TD><TD>50</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is there a way to make this in the script while loading this data?&nbsp;</P><P>Today the data is loaded like this:</P><DIV>LOAD</DIV><DIV>Key,</DIV><DIV>Content AS Firstname</DIV><DIV>FROM</DIV><DIV>data.qvd (qvd)</DIV><DIV>WHERE&nbsp;</DIV><DIV>name = 'Firstname';</DIV><DIV>&nbsp;</DIV><DIV>JOIN</DIV><DIV>&nbsp;</DIV><DIV><DIV>LOAD</DIV><DIV>Key,</DIV><DIV>Content AS Lastname</DIV><DIV>FROM</DIV><DIV>data.qvd (qvd)</DIV><DIV>WHERE&nbsp;</DIV><DIV>name = 'Lastname';</DIV><DIV>...</DIV><DIV>...</DIV><DIV>and so on</DIV></DIV><P>Kind regards, Jonathan</P> Thu, 26 Aug 2021 11:32:11 GMT https://community.qlik.com/t5/App-Development/Transform-table-in-script/m-p/1831352#M68544 Jonathan_Alm 2021-08-26T11:32:11Z https://community.qlik.com/t5/App-Development/Transform-table-in-script/m-p/1831370#M68548 <P>Found the answer.</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470</A></P> Thu, 26 Aug 2021 11:56:13 GMT https://community.qlik.com/t5/App-Development/Transform-table-in-script/m-p/1831370#M68548 Jonathan_Alm 2021-08-26T11:56:13Z