I am having a newbie script problem with Qlikview that I was hoping someone could quickly help me with. I have some customer order data that includes the order number and order comments spread across multiple sequence lines. An example of the data is below the code example. I need to concatenate all of the sequence lines into a single record per each unique order #. I know I need to loop through the data (somehow) to read each line, but I am at a loss on how to accomplish that...?
Any help is greatly appreciated.
OrderComments: LOAD "ORDER_NUM" as OrderNum, "SEQUENCE" as "OrdCom_Sequence", "BOL_COMMENT" as "Order_Comment" FROM ..\AllCompqvdfiles\GMFORDFC.qvd (qvd) WHERE COMPANY='$(Comp)';
Table:LOAD * INLINE [Order, Seq, Comments435350, 1, order1 comments here from customer435350, 2, order2 comments here from customer435350, 3, order3 comments here from customer435350, 4, order4 comments here from customer]; OrderTable:LOAD Order, Concat(Comments, '$$') AS OrderSeqandCommentsRESIDENT TableGROUP BY Order;
Concat() Function aggregates text expressions (fields, in this case).