topic Convert Column to Rows in QlikView https://community.qlik.com/t5/QlikView/Convert-Column-to-Rows/m-p/73405#M785041 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have one requirement as below. I have sample data like</P><P></P><P><STRONG>IMEI, contentype</STRONG></P><P>1236548989,Message</P><P>1236548989,Audio</P><P>1236548989,Images</P><P>1236548987,Message</P><P>1236548987,Vedio</P><P></P><P>I need this to be converted as</P><P></P><P><STRONG>IMEI, contentype</STRONG></P><P>1236548989,Message,Audio,Images</P><P>1236548987,Message,Vedio</P><P></P><P>Pls. suggest.</P><P></P><P>Br, Balanandam</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT balanandam 2020-11-25T16:16:04Z Convert Column to Rows https://community.qlik.com/t5/QlikView/Convert-Column-to-Rows/m-p/73405#M785041 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have one requirement as below. I have sample data like</P><P></P><P><STRONG>IMEI, contentype</STRONG></P><P>1236548989,Message</P><P>1236548989,Audio</P><P>1236548989,Images</P><P>1236548987,Message</P><P>1236548987,Vedio</P><P></P><P>I need this to be converted as</P><P></P><P><STRONG>IMEI, contentype</STRONG></P><P>1236548989,Message,Audio,Images</P><P>1236548987,Message,Vedio</P><P></P><P>Pls. suggest.</P><P></P><P>Br, Balanandam</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-Column-to-Rows/m-p/73405#M785041 balanandam 2020-11-25T16:16:04Z Re: Convert Column to Rows https://community.qlik.com/t5/QlikView/Convert-Column-to-Rows/m-p/73406#M785042 <HTML><HEAD></HEAD><BODY><P>Hi, this can be done&nbsp; with Concat(), inscript needs a Group By clause:</P><P>LOAD</P><P>&nbsp; IMEI,</P><P>&nbsp; Concat(contentype, ',') as <SPAN style="font-size: 13.3333px;">contentype</SPAN></P><P><SPAN style="font-size: 13.3333px;">Resident/from...</SPAN></P><P><SPAN style="font-size: 13.3333px;">Group by IMEI;</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Edit: and maybe<SPAN style="font-size: 13.3333px;"> Concat(<STRONG>distinct</STRONG> contentype, ',') if you want to avoid repeated values.</SPAN><BR /></SPAN></P></BODY></HTML> Thu, 08 Mar 2018 11:08:09 GMT https://community.qlik.com/t5/QlikView/Convert-Column-to-Rows/m-p/73406#M785042 rubenmarin 2018-03-08T11:08:09Z Re: Convert Column to Rows https://community.qlik.com/t5/QlikView/Convert-Column-to-Rows/m-p/73407#M785043 <HTML><HEAD></HEAD><BODY><P>Check this article on a generic load (reverse crosstable)&nbsp; <A href="https://qlikies.wordpress.com/2016/02/22/the-generic-load/" title="https://qlikies.wordpress.com/2016/02/22/the-generic-load/">https://qlikies.wordpress.com/2016/02/22/the-generic-load/</A></P></BODY></HTML> Thu, 08 Mar 2018 11:08:58 GMT https://community.qlik.com/t5/QlikView/Convert-Column-to-Rows/m-p/73407#M785043 jwjackso 2018-03-08T11:08:58Z