2 Replies Latest reply: Apr 29, 2016 4:37 PM by Ron Payne RSS

    Fitting several rows onto one row with Concat()?

    Ron Payne

      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!