0 Replies Latest reply: Apr 5, 2017 5:59 PM by Colin Flynn RSS

    How to aggregate the results of table in load script

    Colin Flynn

      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").

       

      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.

       

      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.

       

      Any help would be appreciated. Thank you.

       

      Straight_Table.PNG