topic Re: From row to column in QlikView https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466142#M562125 <HTML><HEAD></HEAD><BODY><P>That is exactly the solution for what I was looking for!</P><P></P><P>Many thanks!</P></BODY></HTML> Thu, 21 Mar 2013 15:51:22 GMT 2013-03-21T15:51:22Z From row to column https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466137#M562120 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have a problem to solve where might someone is able to give me a hint.</P><P></P><P>Current situation (Example):</P><P></P><P>ItemCode&nbsp;&nbsp;&nbsp;&nbsp; /&nbsp;&nbsp;&nbsp;&nbsp; Manufacturer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&nbsp;&nbsp;&nbsp; ManufacturerOrderCode</P><P>1111111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AAA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; XY2A</P><P>1111111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BBB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z3ZZ</P><P>1111111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CCC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1XYA</P><P>2222222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HHH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L1LL</P><P>2222222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GGG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L1LL</P><P>3333333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z4Z3Z</P><P></P><P></P><P></P><P>What i need at the end:</P><P></P><P>ItemCode&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manufacturer1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ManufacturerOrderCode1&nbsp;&nbsp;&nbsp;&nbsp; Manufacturer2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ManufacturerOrderCode2&nbsp;&nbsp;&nbsp;&nbsp; Manufacturer3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ManufacturerOrderCode3</P><P>1111111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AAA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; XY2A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BBB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z3ZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CCC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1XYA</P><P>2222222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HHH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L1LL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GGG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L1LL</P><P>3333333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZZZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z4Z3Z</P><P></P><P></P><P>It means I would like to get for each Manufacturer and ManufacturerOrderCode an extra column instead of a new row.</P><P></P><P>Thanks in advance</P><P></P><P>BR</P></BODY></HTML> Thu, 21 Mar 2013 13:56:57 GMT https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466137#M562120 2013-03-21T13:56:57Z Re: From row to column https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466138#M562121 <HTML><HEAD></HEAD><BODY><P>Hi i think u need to&nbsp; use generic load to get the data&nbsp; with the above format...</P></BODY></HTML> Thu, 21 Mar 2013 14:10:57 GMT https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466138#M562121 shree909 2013-03-21T14:10:57Z Re: From row to column https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466139#M562122 <HTML><HEAD></HEAD><BODY><P>A:</P><P>LOAD </P><P>ItemCode,</P><P>Manufacturer,</P><P>ManufacturerOrderCode</P><P>FROM TABLE1;</P><P></P><P>Generic load&nbsp; ItemCode, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Manufacturer ' &amp;&nbsp; ItemCode,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Manufacturer</P><P>resident A;</P><P></P><P>Generic load&nbsp; ItemCode, </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'ManufacturerOrderCode ' &amp;&nbsp; ItemCode,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ManufacturerOrderCode</P><P>resident A;</P></BODY></HTML> Thu, 21 Mar 2013 14:13:24 GMT https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466139#M562122 2013-03-21T14:13:24Z Re: From row to column https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466140#M562123 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Many thanks for your idea!</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">The problem is that I have more than 200'000 rows in my table which has to be transformed. Any faster and slimer solution</SPAN>?</P></BODY></HTML> Thu, 21 Mar 2013 15:09:21 GMT https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466140#M562123 2013-03-21T15:09:21Z Re: From row to column https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466141#M562124 <HTML><HEAD></HEAD><BODY><P>Wrecking the data model like that sounds like an exceedingly bad idea to me. Try using a pivot table instead. See attached example.</P></BODY></HTML> Thu, 21 Mar 2013 15:43:56 GMT https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466141#M562124 Gysbert_Wassenaar 2013-03-21T15:43:56Z Re: From row to column https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466142#M562125 <HTML><HEAD></HEAD><BODY><P>That is exactly the solution for what I was looking for!</P><P></P><P>Many thanks!</P></BODY></HTML> Thu, 21 Mar 2013 15:51:22 GMT https://community.qlik.com/t5/QlikView/From-row-to-column/m-p/466142#M562125 2013-03-21T15:51:22Z