
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Concat rows in Load Script
Hi,
I am relatively new to QlikSense and I have read many posts on Concatenating in Load Scripts but I still can not find a solution.
I have a list of Orders and each order can have Multiple Statuses i.e.
Order Status
123 A
123 B
456 A
456 B
456 C
I would like to see a result of:
Order Status
123 A,B
456 A,B,C
I am loading data from an excel document i.e.
LOAD
Order,
Status
FROM [lib://50.Operations_SourceFiles/Productivity-MasterX.xlsm]
(ooxml, embedded labels, table is PlannedVActual);
From what I have read, I need to concat the data and group but what script do I need to add to the above please?
Thanks
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can try concat on resident load like below
Data:
load Plnt,
....
Order
FROM Source
left join (Data)
load Order,
concat(distinct Stat,',') as Status
resident Data
group by Order;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LOAD
Order,
concat( distinct Status,',') as Status
FROM [lib://50.Operations_SourceFiles/Productivity-MasterX.xlsm]
(ooxml, embedded labels, table is PlannedVActual)
group by Order;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Kush,
Thank you for the reply, unfortunately I get an ' Invalid Expression' Error
I have taken a screen shot of the full script. Thanks in Advance. Ben

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
screenshot is missing

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is it visible now? Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can try concat on resident load like below
Data:
load Plnt,
....
Order
FROM Source
left join (Data)
load Order,
concat(distinct Stat,',') as Status
resident Data
group by Order;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Kush,
That worked great.
Thank you for the help
Ben
