topic Re: How to Transform row to Column and Column to Row in QlikView

topic Re: How to Transform row to Column and Column to Row in QlikView https://community.qlik.com/t5/QlikView/How-to-Transform-row-to-Column-and-Column-to-Row/m-p/1094195#M935643 <HTML><HEAD></HEAD><BODY><P>For row to column you can use Generic Load - <A href="https://community.qlik.com/qlik-blogpost/3629">The Generic Load</A></P><P>For column to row you can use CrossTable Load - <A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Tue, 23 Feb 2016 17:49:27 GMT sunny_talwar 2016-02-23T17:49:27Z How to Transform row to Column and Column to Row https://community.qlik.com/t5/QlikView/How-to-Transform-row-to-Column-and-Column-to-Row/m-p/1094194#M935642 <HTML><HEAD></HEAD><BODY><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">Lot  No</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Barcode</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Process</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Marks1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Marks 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 6</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 7</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 8</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 9</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 10</STRONG></TH></TR><TR><TD style="padding: 2px;">A1</TD><TD style="padding: 2px;">A1-001</TD><TD style="padding: 2px;">1 Pred</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">A1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">A1-001</SPAN></TD><TD style="padding: 2px;">2 pred</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">A1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">A1-001</SPAN></TD><TD style="padding: 2px;">3 pred</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">A1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">A1-001</SPAN></TD><TD style="padding: 2px;">Final</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">B1-001</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">1 Pred</SPAN></TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">B1-001</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">2 pred</SPAN></TD><TD style="padding: 2px;">43</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">B1-001</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">3 pred</SPAN></TD><TD style="padding: 2px;">34</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">B1-001</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">Final</SPAN></TD><TD style="padding: 2px;">54</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 23 Feb 2016 10:27:07 GMT https://community.qlik.com/t5/QlikView/How-to-Transform-row-to-Column-and-Column-to-Row/m-p/1094194#M935642 brijeshvma 2016-02-23T10:27:07Z Re: How to Transform row to Column and Column to Row https://community.qlik.com/t5/QlikView/How-to-Transform-row-to-Column-and-Column-to-Row/m-p/1094195#M935643 <HTML><HEAD></HEAD><BODY><P>For row to column you can use Generic Load - <A href="https://community.qlik.com/qlik-blogpost/3629">The Generic Load</A></P><P>For column to row you can use CrossTable Load - <A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P></BODY></HTML> Tue, 23 Feb 2016 17:49:27 GMT https://community.qlik.com/t5/QlikView/How-to-Transform-row-to-Column-and-Column-to-Row/m-p/1094195#M935643 sunny_talwar 2016-02-23T17:49:27Z