topic Re: ROW to comma Separated String in QlikView in QlikView https://community.qlik.com/t5/QlikView/ROW-to-comma-Separated-String-in-QlikView/m-p/1284344#M402317 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;"><BR /> Data:<BR /> </SPAN><SPAN style="; color: #0000ff; font-size: 8pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /> Line_id<BR /> 1001<BR /> 1002<BR /> 1003<BR /> 1004<BR /> ]</SPAN><SPAN style="font-size: 8pt;">;<BR /> <BR /><SPAN style="color: #808080;"> </SPAN></SPAN><SPAN style="color: #808080; font-size: 8pt;">Data2:</SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="; color: #0000ff; font-size: 8pt;"><STRONG>load</STRONG></SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Line_id</SPAN><SPAN style="font-size: 8pt;">,',') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">New_line_ID</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Resident</SPAN><SPAN style="font-size: 8pt;"> Data; </SPAN></P></BODY></HTML> Tue, 06 Dec 2016 06:59:13 GMT Anonymous 2016-12-06T06:59:13Z ROW to comma Separated String in QlikView https://community.qlik.com/t5/QlikView/ROW-to-comma-Separated-String-in-QlikView/m-p/1284343#M402316 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have data as below in one of my QVD file,</P><P></P><P><STRONG>Line_id</STRONG></P><P><STRONG>1001</STRONG></P><P><STRONG>1002</STRONG></P><P><STRONG>1003</STRONG></P><P><STRONG>1004</STRONG></P><P><STRONG><BR /></STRONG></P><P>my requirement is to show data as below while loading that into QVW file.</P><P></P><P><STRONG>1001,1002,1003,1004</STRONG></P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 06 Dec 2016 06:42:49 GMT https://community.qlik.com/t5/QlikView/ROW-to-comma-Separated-String-in-QlikView/m-p/1284343#M402316 infosense_devel 2016-12-06T06:42:49Z Re: ROW to comma Separated String in QlikView https://community.qlik.com/t5/QlikView/ROW-to-comma-Separated-String-in-QlikView/m-p/1284344#M402317 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;"><BR /> Data:<BR /> </SPAN><SPAN style="; color: #0000ff; font-size: 8pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 8pt;"> * </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /> Line_id<BR /> 1001<BR /> 1002<BR /> 1003<BR /> 1004<BR /> ]</SPAN><SPAN style="font-size: 8pt;">;<BR /> <BR /><SPAN style="color: #808080;"> </SPAN></SPAN><SPAN style="color: #808080; font-size: 8pt;">Data2:</SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="; color: #0000ff; font-size: 8pt;"><STRONG>load</STRONG></SPAN><SPAN style="font-size: 8pt;"><BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Line_id</SPAN><SPAN style="font-size: 8pt;">,',') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">New_line_ID</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Resident</SPAN><SPAN style="font-size: 8pt;"> Data; </SPAN></P></BODY></HTML> Tue, 06 Dec 2016 06:59:13 GMT https://community.qlik.com/t5/QlikView/ROW-to-comma-Separated-String-in-QlikView/m-p/1284344#M402317 Anonymous 2016-12-06T06:59:13Z