topic How to aggregate the results of table in load script in App Development https://community.qlik.com/t5/App-Development/How-to-aggregate-the-results-of-table-in-load-script/m-p/1348995#M29975 <HTML><HEAD></HEAD><BODY><P>Hi I am creating a table by concatenating records, and the result is not coming the way I would like for it to. The data from my fields are not associating properly, even though they are all associated to the key field ("Submission ID").</P><P></P><P>You see I have the same Submission ID 10-times. It is ideal for me to be able to aggregate the data in this straight table so that I do not have so many null (---) values. </P><P></P><P>Is there a way to do this in the load script? I tried a combination of using Concat (Fields) and Subfield, but this does not work properly when a Submission has 2 or more products. </P><P></P><P>Any help would be appreciated. Thank you.</P><P></P><P><IMG alt="Straight_Table.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159174_Straight_Table.PNG" style="height: 188px; width: 620px;" /></P></BODY></HTML> Wed, 05 Apr 2017 21:59:00 GMT 2017-04-05T21:59:00Z How to aggregate the results of table in load script https://community.qlik.com/t5/App-Development/How-to-aggregate-the-results-of-table-in-load-script/m-p/1348995#M29975 <HTML><HEAD></HEAD><BODY><P>Hi I am creating a table by concatenating records, and the result is not coming the way I would like for it to. The data from my fields are not associating properly, even though they are all associated to the key field ("Submission ID").</P><P></P><P>You see I have the same Submission ID 10-times. It is ideal for me to be able to aggregate the data in this straight table so that I do not have so many null (---) values. </P><P></P><P>Is there a way to do this in the load script? I tried a combination of using Concat (Fields) and Subfield, but this does not work properly when a Submission has 2 or more products. </P><P></P><P>Any help would be appreciated. Thank you.</P><P></P><P><IMG alt="Straight_Table.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/159174_Straight_Table.PNG" style="height: 188px; width: 620px;" /></P></BODY></HTML> Wed, 05 Apr 2017 21:59:00 GMT https://community.qlik.com/t5/App-Development/How-to-aggregate-the-results-of-table-in-load-script/m-p/1348995#M29975 2017-04-05T21:59:00Z