4 Replies Latest reply: Aug 24, 2016 6:21 AM by Keith Curley RSS

    Delete aggregated records in load script?

    Keith Curley

      Hi All,

       

      I am loading Orders data where each Order comprises of several rows of data. Every finished order consists of (at least one) Goods Issue line, plus a Goods Receipt and a Settlement, something like this:

       

      Order #TransactionQuantity
      101Goods Issue25
      101Goods Issue20
      101Goods Receipt45
      101Settlement45

        

      However, my dataset also contains incomplete/WIP orders which will not have a Settlement and/or Receipt.

       

      Does anyone know how I can do a selective load on the aggregated rows which make up one order?

      i.e. only load the collective rows which make up an order where the rows contain a Goods Issue, Goods Receipt and a Settlement line.

       

      Thanks in advance for your support,

       

      Keith