Discussion Board for collaboration related to QlikView App Development.
I'm try to collapse multiple order lines to a single order line when loading them via a script, it's a bit hard to describe but the following should help clarify:
This is the data I'm trying to load:
And this is how I need to display it:
Hope this makes sense, any help would be appreciated!
You could use concat function
Try like this below
Concat(ItemNo, ',') AS [Combined Item]
Group By [Order ID];
View solution in original post
use conca function in load script. find the attachment
Try creating a straight table with dimension as Order ID and expression Concat(ITEM,' ').
Use Concat() Function.
TABLE:LOAD * INLINE [Order ID, ITEM 1178, A 1178, C 1178, D 1180, B 1180, E 1195, A 1195, B 1195, C 1195, D 1108, A];
CONCAT_TABLE:LOAD [Order ID],Concat(ITEM,' ') AS [Items Ordered]
RESIDENT TABLE GROUP BY [Order ID];DROP TABLE TABLE;
Hope that helps.
Thanks for your help, I thought I needed to use concat function but wasn't sure how the Group By would work.