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

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

magnusrydberg — Wed, 08 Feb 2017 13:39:54 GMT

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

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

ahaahaaha — Wed, 08 Feb 2017 14:20:18 GMT

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