11 Replies Latest reply: Apr 2, 2017 3:11 AM by Massimo Grossi RSS

    creating a new table

    Ronit Kanfi

      Hello :-)

       

      I have two tables with invoice data:

      Invoice:

      LOAD

        IV,

        PART, //PAYPART

      QUANT as PAYQUANT

      InvoiceDetailed:

      LOAD

          IV,

          PART, //ACTUALPART

          QUANT as ACTUALQUANT

      for example:

      Invoice table:

      IV  PART    PAYQUANT

      19    XXX   15

      19    ZZZ    13

      InvoiceDetailed table:

      IV    PART    ACTUALQUANT

      19    XXX    15

      19    YYY    22


      What I need is to have a final table with all Possibilities:

      IV    PART    PAYQUANT    ACTUALQUANT

      19     XXX     15                    15

      19     ZZZ      13                     0

      19     YYY      0                      22

       

      I would appreiciate your help in finding a solution.