topic Re: Table transformation in QlikView https://community.qlik.com/t5/QlikView/Table-transformation/m-p/616798#M679380 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Patrick!</P></BODY></HTML> Thu, 24 Apr 2014 15:57:20 GMT salto 2014-04-24T15:57:20Z Table transformation https://community.qlik.com/t5/QlikView/Table-transformation/m-p/616796#M679378 <HTML><HEAD></HEAD><BODY><P>Hello Community!</P><P></P><P>I have a table like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Row</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Formula</STRONG></TH></TR><TR><TD style="padding: 2px;">BS0500</TD><TD style="padding: 2px;">BS0510</TD></TR><TR><TD style="padding: 2px;">BS0500</TD><TD style="padding: 2px;">BS0520</TD></TR><TR><TD style="padding: 2px;">BS0510</TD><TD style="padding: 2px;">240</TD></TR><TR><TD style="padding: 2px;">BS0510</TD><TD style="padding: 2px;">249</TD></TR><TR><TD style="padding: 2px;">BS0510</TD><TD style="padding: 2px;">293</TD></TR><TR><TD style="padding: 2px;">BS0520</TD><TD style="padding: 2px;">242</TD></TR><TR><TD style="padding: 2px;">BS0520</TD><TD style="padding: 2px;">295</TD></TR></TBODY></TABLE><P></P><P>And I would like to convert / expand it to this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">BS0500</TD><TD style="padding: 2px;">240</TD></TR><TR><TD style="padding: 2px;">BS0500</TD><TD style="padding: 2px;">249</TD></TR><TR><TD style="padding: 2px;">BS0500</TD><TD style="padding: 2px;">293</TD></TR><TR><TD style="padding: 2px;">BS0500</TD><TD style="padding: 2px;">242</TD></TR><TR><TD style="padding: 2px;">BS0500</TD><TD style="padding: 2px;">295</TD></TR><TR><TD style="padding: 2px;">BS0510</TD><TD style="padding: 2px;">240</TD></TR><TR><TD style="padding: 2px;">BS0510</TD><TD style="padding: 2px;">249</TD></TR><TR><TD style="padding: 2px;">BS0510</TD><TD style="padding: 2px;">293</TD></TR><TR><TD style="padding: 2px;">BS0520</TD><TD style="padding: 2px;">242</TD></TR><TR><TD style="padding: 2px;">BS0520</TD><TD style="padding: 2px;">295</TD></TR></TBODY></TABLE><P></P><P>Any help would be highly appreciated!</P><P>Thanks in advance.</P></BODY></HTML> Thu, 24 Apr 2014 15:38:21 GMT https://community.qlik.com/t5/QlikView/Table-transformation/m-p/616796#M679378 salto 2014-04-24T15:38:21Z Re: Table transformation https://community.qlik.com/t5/QlikView/Table-transformation/m-p/616797#M679379 <HTML><HEAD></HEAD><BODY><P>Hi, you can try this in the script - </P><P>HTH!</P><P></P><P></P><P>tab:</P><P>load * Inline [</P><P>_Row, Formula</P><P>BS0500, BS0510</P><P>BS0500, BS0520</P><P>BS0510, 240</P><P>BS0510, 249</P><P>BS0510, 293</P><P>BS0520, 242</P><P>BS0520, 295</P><P>];</P><P></P><P>Tmp:</P><P>load _Row, Formula as _F </P><P>resident tab;</P><P></P><P>left join</P><P></P><P>load</P><P> _Row as _F, Formula</P><P>Resident tab;</P><P></P><P>drop table tab;</P><P></P><P>Fnl:</P><P>load _Row as Row,</P><P>&nbsp; if(isnull(Formula), _F, Formula) as Formula</P><P>resident Tmp;</P><P></P><P>drop table Tmp;</P></BODY></HTML> Thu, 24 Apr 2014 15:52:56 GMT https://community.qlik.com/t5/QlikView/Table-transformation/m-p/616797#M679379 2014-04-24T15:52:56Z Re: Table transformation https://community.qlik.com/t5/QlikView/Table-transformation/m-p/616798#M679380 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Patrick!</P></BODY></HTML> Thu, 24 Apr 2014 15:57:20 GMT https://community.qlik.com/t5/QlikView/Table-transformation/m-p/616798#M679380 salto 2014-04-24T15:57:20Z