Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rpayn01215
Contributor

Fitting several rows onto one row with Concat()?

Hi,

I'm trying to fit my serial number column onto one row. When there is more than one serial # per sales order, it causes duplication of the order quantity. Is it possible to squeeze these serials onto one row with Concat() or some other function in the script?

What it's looking like now:

SalesOrder  Serial #Order Qty
10439573220942
10439573142372

What it needs to look like:

              Sales Order   Serial #Order Qty
1043957   322094 3142372

Any help or suggestions is much appreciated. The extra rows are duplicating my order quantity.

Thanks a lot!

1 Solution

Accepted Solutions

Re: Fitting several rows onto one row with Concat()?

Try something like this:

Load [SalesOrder], concat([Serial#], '|') as SerialConcat, sum([Order Qty]) as [Order Qty]

From YourSource Group By [SalesOrder];

- Marcus

2 Replies

Re: Fitting several rows onto one row with Concat()?

Try something like this:

Load [SalesOrder], concat([Serial#], '|') as SerialConcat, sum([Order Qty]) as [Order Qty]

From YourSource Group By [SalesOrder];

- Marcus

rpayn01215
Contributor

Re: Fitting several rows onto one row with Concat()?

Thanks Marcus!

Community Browser