topic Re: Need Help to concatinate multiple rows into one in QlikView https://community.qlik.com/t5/QlikView/Need-Help-to-concatinate-multiple-rows-into-one/m-p/692294#M1056940 <HTML><HEAD></HEAD><BODY><P>See the example in attachment. This is done in the UI. You can use the same concat() technique in your script when creating a new table. In that case, add the GROUP BY clause.</P><P></P><P>BTW the output of concat() can be sorted differently by specifying a third parameter.</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Fri, 24 Oct 2014 13:57:12 GMT Peter_Cammaert 2014-10-24T13:57:12Z Need Help to concatinate multiple rows into one https://community.qlik.com/t5/QlikView/Need-Help-to-concatinate-multiple-rows-into-one/m-p/692293#M1056939 <HTML><HEAD></HEAD><BODY><P>I have a sistuation were I can have multiple lrows for the same associates.&nbsp; The number of rows may very could be one could be 10.&nbsp; I need to combine all the rows into one using a specific format for the beneficiary.&nbsp; I have attached a sample of raw data&nbsp; and what I would nee the result to be. Any help would be appreciated.</P></BODY></HTML> Fri, 24 Oct 2014 13:45:17 GMT https://community.qlik.com/t5/QlikView/Need-Help-to-concatinate-multiple-rows-into-one/m-p/692293#M1056939 2014-10-24T13:45:17Z Re: Need Help to concatinate multiple rows into one https://community.qlik.com/t5/QlikView/Need-Help-to-concatinate-multiple-rows-into-one/m-p/692294#M1056940 <HTML><HEAD></HEAD><BODY><P>See the example in attachment. This is done in the UI. You can use the same concat() technique in your script when creating a new table. In that case, add the GROUP BY clause.</P><P></P><P>BTW the output of concat() can be sorted differently by specifying a third parameter.</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Fri, 24 Oct 2014 13:57:12 GMT https://community.qlik.com/t5/QlikView/Need-Help-to-concatinate-multiple-rows-into-one/m-p/692294#M1056940 Peter_Cammaert 2014-10-24T13:57:12Z