topic Re: row into colomns in QlikView https://community.qlik.com/t5/QlikView/row-into-colomns/m-p/798581#M1020947 <HTML><HEAD></HEAD><BODY><P>Try Cross Table or generic load.</P><P>Your Word file can not be opened..</P></BODY></HTML> Thu, 26 Mar 2015 13:00:19 GMT robert_mika 2015-03-26T13:00:19Z row into colomns https://community.qlik.com/t5/QlikView/row-into-colomns/m-p/798580#M1020946 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;"><BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">,'DD/MM/YYY') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">As</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Dimension</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">TxnType</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">WOS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Distribution</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Seller HQFlag]</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Outlet Type]</SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #008000; font-size: 8pt;">// Region, <BR /> // ModelCode<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR /> <D><BR /> (</D></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">qvd</SPAN><SPAN style="font-size: 8pt;">);<BR /> </SPAN><SPAN style="color: #008000; font-size: 8pt;">//Left Join<BR /> </SPAN><SPAN style="font-size: 8pt;"><BR /> Meess_Temp1:<BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">,'DD/MM/YYY') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">As</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Dimension</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">TxnType</SPAN><SPAN style="font-size: 8pt;">, <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">WOS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Distribution</SPAN><SPAN style="font-size: 8pt;">,<BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Outlet Type]</SPAN><SPAN style="font-size: 8pt;"> <BR /> <BR /> </SPAN><SPAN style="color: #008000; font-size: 8pt;">// Region, <BR /> // ModelCode<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FROM</SPAN><SPAN style="font-size: 8pt;"><BR /> <D><BR /> (</D></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">qvd</SPAN><SPAN style="font-size: 8pt;">);<BR /> </SPAN></P><P>i have input like below i attached .i want to get</P><P></P><P>Out letType&nbsp; D-2&nbsp; Wk-1&nbsp; Wk-2 </P><P>Distribution&nbsp; 4.9&nbsp;&nbsp; 4.8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.7</P><P></P><P>like this i want output.</P><P></P><P>the implementation must be done in scripting side ony.</P><P>plz help me</P><P><BR /> </P></BODY></HTML> Thu, 26 Mar 2015 12:54:58 GMT https://community.qlik.com/t5/QlikView/row-into-colomns/m-p/798580#M1020946 2015-03-26T12:54:58Z Re: row into colomns https://community.qlik.com/t5/QlikView/row-into-colomns/m-p/798581#M1020947 <HTML><HEAD></HEAD><BODY><P>Try Cross Table or generic load.</P><P>Your Word file can not be opened..</P></BODY></HTML> Thu, 26 Mar 2015 13:00:19 GMT https://community.qlik.com/t5/QlikView/row-into-colomns/m-p/798581#M1020947 robert_mika 2015-03-26T13:00:19Z