topic Re: How to rotate values into dimension with qlikview in QlikView https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423774#M700086 <HTML><HEAD></HEAD><BODY><P>Thank's a lot Jeffmartins, </P><P>it's roughly what I needed.</P></BODY></HTML> Mon, 29 Oct 2012 14:19:26 GMT 2012-10-29T14:19:26Z How to rotate values into dimension with qlikview https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423771#M700083 <HTML><HEAD></HEAD><BODY><P>Hello EveryBody , </P><P>I would like to know how i can transform my values from lines to column with my script during a load statement. Let's look at this example :</P><P></P><P>I have this:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="126" style="border: 1px solid rgb(0, 0, 0); width: 540px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Code</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>A</TD><TD>3</TD></TR><TR><TD>1</TD><TD>B</TD><TD>2</TD></TR><TR><TD>1</TD><TD>C</TD><TD>1</TD></TR><TR><TD>2</TD><TD>D</TD><TD>4</TD></TR></TBODY></TABLE><P></P><P></P><P>I would like to have this:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="77" style="border: 1px solid rgb(0, 0, 0); width: 541px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>A<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>B<BR /></STRONG></SPAN></P></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>C<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>D<BR /></STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>3</TD><TD>2</TD><TD>1</TD><TD><BR /></TD></TR><TR><TD>2</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD>4</TD></TR></TBODY></TABLE><P></P><P>Thank you in advance, </P><P></P><P>Best Regards</P></BODY></HTML> Wed, 17 Oct 2012 15:23:45 GMT https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423771#M700083 2012-10-17T15:23:45Z Re: How to rotate values into dimension with qlikview https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423772#M700084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>have a look at using the transformation step on step 2 of the table wizard in load script.</P><P></P><P>Transformation Step -&gt; Rotate -&gt; Transpose</P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.800000190734863px; background-color: #f5f5f5;"><IMG __jive_id="23609" alt="screenshot.2.jpg" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/23609_screenshot.2.jpg" width="450" /></SPAN></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.800000190734863px; background-color: #f5f5f5;"><IMG __jive_id="23610" alt="screenshot.3.jpg" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/23610_screenshot.3.jpg" width="450" /></SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.800000190734863px; background-color: #f5f5f5;">Regards</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.800000190734863px; background-color: #f5f5f5;">MC<BR /></SPAN></P></BODY></HTML> Wed, 17 Oct 2012 15:34:03 GMT https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423772#M700084 2012-10-17T15:34:03Z Re: How to rotate values into dimension with qlikview https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423773#M700085 <HTML><HEAD></HEAD><BODY><P>Hi laguerrethom,</P><P></P><P>I had the same problem and solved it with the code described in the attached file.</P><P></P><P>Regards&nbsp; </P></BODY></HTML> Wed, 17 Oct 2012 18:11:53 GMT https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423773#M700085 jeffmartins 2012-10-17T18:11:53Z Re: How to rotate values into dimension with qlikview https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423774#M700086 <HTML><HEAD></HEAD><BODY><P>Thank's a lot Jeffmartins, </P><P>it's roughly what I needed.</P></BODY></HTML> Mon, 29 Oct 2012 14:19:26 GMT https://community.qlik.com/t5/QlikView/How-to-rotate-values-into-dimension-with-qlikview/m-p/423774#M700086 2012-10-29T14:19:26Z