How do I create an aggregated file in a Qlik Sqript?

[magnusrydberg]

I have a file containing comments on an order. This comments are created at different times and therefore in different records, many comment records on one order.

I now want to create a new file in my QV script containing one comment record per order. This new record should be a sum of all the different comments in the old file.

See attached file for further explanation

[ahaahaaha]

Hi Magnus,

Try as

LOAD

    "Order",

    Concat("Comment")

FROM [lib://!D/How to create new  file in a qlik Sqript.xlsx] //here is the path to your file xlsx

(ooxml, embedded labels, header is 1 lines, table is Blad1)

Group By "Order";

Result

Regards,

Andrey