topic How to concatinate records goroupping by value in QlikView https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377573#M608635 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>I new in qlik community and <SPAN lang="en">I apologize for the trivial question.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P>I have dataset:</P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid #000000; width: 66px; height: 133px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">f</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">m</TD></TR></TBODY></TABLE><P>And I need to get:</P><TABLE border="1" class="jiveBorder" height="80" style="border: 1px solid #000000; width: 84px; height: 74px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a, b, c</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">a, f</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c, m</TD></TR></TBODY></TABLE><P></P><P>How can I do it in data loader?</P><P></P><P>Thank you very much.</P></BODY></HTML> Sun, 10 Dec 2017 15:42:49 GMT Anonymous 2017-12-10T15:42:49Z How to concatinate records goroupping by value https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377573#M608635 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>I new in qlik community and <SPAN lang="en">I apologize for the trivial question.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P>I have dataset:</P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid #000000; width: 66px; height: 133px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">b</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">a</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">f</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">m</TD></TR></TBODY></TABLE><P>And I need to get:</P><TABLE border="1" class="jiveBorder" height="80" style="border: 1px solid #000000; width: 84px; height: 74px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">a, b, c</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">a, f</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">c, m</TD></TR></TBODY></TABLE><P></P><P>How can I do it in data loader?</P><P></P><P>Thank you very much.</P></BODY></HTML> Sun, 10 Dec 2017 15:42:49 GMT https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377573#M608635 Anonymous 2017-12-10T15:42:49Z Re: How to concatinate records goroupping by value https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377574#M608636 <HTML><HEAD></HEAD><BODY><P><A href="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StringAggregationFunctions/concat.htm" title="http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StringAggregationFunctions/concat.htm">Concat - chart function ‒ QlikView</A></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 10 Dec 2017 23:08:52 GMT https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377574#M608636 MarcoWedel 2017-12-10T23:08:52Z Re: How to concatinate records goroupping by value https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377575#M608637 <HTML><HEAD></HEAD><BODY><P>In the LOAD script, use a LOAD with an aggregation function and a GROUP BY clause, like</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; YourNumericFieldName,</P><P>&nbsp;&nbsp;&nbsp; <STRONG>Concat( YourCharFieldName, ', ')</STRONG> as ConcatenatedChars</P><P>FROM ....</P><P><STRONG>GROUP BY </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>YourNumericFieldName;</STRONG></SPAN></P></BODY></HTML> Sun, 10 Dec 2017 23:30:09 GMT https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377575#M608637 swuehl 2017-12-10T23:30:09Z Re: How to concatinate records goroupping by value https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377576#M608638 <HTML><HEAD></HEAD><BODY><P>It works!</P><P>Thank you very much! </P></BODY></HTML> Mon, 11 Dec 2017 04:44:37 GMT https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377576#M608638 Anonymous 2017-12-11T04:44:37Z Re: How to concatinate records goroupping by value https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377577#M608639 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">This is a very useful article/ </SPAN></P><P><SPAN lang="en">Thanks!<BR /></SPAN></P></BODY></HTML> Mon, 11 Dec 2017 04:46:30 GMT https://community.qlik.com/t5/QlikView/How-to-concatinate-records-goroupping-by-value/m-p/1377577#M608639 Anonymous 2017-12-11T04:46:30Z