topic Convert coma separated values into rows in QlikView https://community.qlik.com/t5/QlikView/Convert-coma-separated-values-into-rows/m-p/336831#M1177744 <HTML><HEAD></HEAD><BODY><P>I found the solution <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>use subfield function</P></BODY></HTML> Wed, 04 Apr 2012 10:48:14 GMT Yousef_Amarneh 2012-04-04T10:48:14Z Convert coma separated values into rows https://community.qlik.com/t5/QlikView/Convert-coma-separated-values-into-rows/m-p/336830#M1177742 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need your help with data included coma separated, and I need to make them as rows while loading.</P><P></P><P>for example:</P><P></P><P><IMG alt="Untitled11.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/12692_Untitled11.png" /></P><P>should be like this </P><P></P><P><IMG alt="Untitled22.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/12693_Untitled22.png" /></P><P></P><P>Any idea?? </P></BODY></HTML> Wed, 04 Apr 2012 10:35:42 GMT https://community.qlik.com/t5/QlikView/Convert-coma-separated-values-into-rows/m-p/336830#M1177742 Yousef_Amarneh 2012-04-04T10:35:42Z Convert coma separated values into rows https://community.qlik.com/t5/QlikView/Convert-coma-separated-values-into-rows/m-p/336831#M1177744 <HTML><HEAD></HEAD><BODY><P>I found the solution <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>use subfield function</P></BODY></HTML> Wed, 04 Apr 2012 10:48:14 GMT https://community.qlik.com/t5/QlikView/Convert-coma-separated-values-into-rows/m-p/336831#M1177744 Yousef_Amarneh 2012-04-04T10:48:14Z