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.