topic Re: concatenate rows and enclose them within single quotes in QlikView https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838060#M656469 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>[Your table]:</P><P>Load concat(CHR(39)&amp;Names&amp;CHR(39),',') as ResultNames;</P><P>LOAD Names</P><P>FROM Your file;</P></BODY></HTML> Fri, 05 Jun 2015 19:07:09 GMT swarup_malli 2015-06-05T19:07:09Z concatenate rows and enclose them within single quotes https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838059#M656468 <HTML><HEAD></HEAD><BODY><P>I have a name field</P><P></P><P>I want to concatenate all the names within single quotes</P><P></P><P>Ex : <STRONG>Name</STRONG></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sam</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adam</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alex</P><P></P><P></P><P></P><P>I want the result to be </P><P>'Sam','John','Adam',' Alex'</P><P></P><P>Want it to be done in script not front end</P><P></P><P>Any ideas ?</P><P></P><P><BR /> </P></BODY></HTML> Fri, 05 Jun 2015 19:06:19 GMT https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838059#M656468 2015-06-05T19:06:19Z Re: concatenate rows and enclose them within single quotes https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838060#M656469 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>[Your table]:</P><P>Load concat(CHR(39)&amp;Names&amp;CHR(39),',') as ResultNames;</P><P>LOAD Names</P><P>FROM Your file;</P></BODY></HTML> Fri, 05 Jun 2015 19:07:09 GMT https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838060#M656469 swarup_malli 2015-06-05T19:07:09Z Re: concatenate rows and enclose them within single quotes https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838061#M656470 <HTML><HEAD></HEAD><BODY><P>T:</P><P>LOAD * INLINE [</P><P>Name</P><P>Sam</P><P>John</P><P>Adam</P><P>Alex</P><P>];</P><P></P><P></P><P>LOAD chr(39) &amp; Concat(Name,chr(39)&amp;','&amp; chr(39)) &amp; chr(39) as value Resident T;</P></BODY></HTML> Fri, 05 Jun 2015 19:09:01 GMT https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838061#M656470 Clever_Anjos 2015-06-05T19:09:01Z Re: concatenate rows and enclose them within single quotes https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838062#M656471 <HTML><HEAD></HEAD><BODY><P>Thank you guys <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Fri, 05 Jun 2015 19:18:36 GMT https://community.qlik.com/t5/QlikView/concatenate-rows-and-enclose-them-within-single-quotes/m-p/838062#M656471 2015-06-05T19:18:36Z