Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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