Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
1043957 | 322094 | 2 |
1043957 | 314237 | 2 |
What it needs to look like:
Sales Order | Serial # | Order Qty |
1043957 | 322094 314237 | 2 |
Any help or suggestions is much appreciated. The extra rows are duplicating my order quantity.
Thanks a lot!
Try something like this:
Load [SalesOrder], concat([Serial#], '|') as SerialConcat, sum([Order Qty]) as [Order Qty]
From YourSource Group By [SalesOrder];
- Marcus
Try something like this:
Load [SalesOrder], concat([Serial#], '|') as SerialConcat, sum([Order Qty]) as [Order Qty]
From YourSource Group By [SalesOrder];
- Marcus
Thanks Marcus!