5 Replies Latest reply: May 19, 2014 7:49 PM by Marco Wedel RSS

    Adding two tables. Do not know how to approach.  Help plz.

    Raghav Kumar

      I have the following data.

      Table 1:

      StateChannelPackingProductValue1
      State1DealerBagProduct1100
      State1DirectBulkProduct2100
      State1DirectBagProduct2100
      State2DealerBagProduct1200
      State2DirectBulkProduct2200

       

      Table 2:

      StateChannelPackingProductValue2
      State1DealerBagProduct110
      State1DirectBulkProduct220

       

      For all the remaining combinations of Table 1 -> Value2 = 50

       

      I need to add Value2 to Value1 and get Table 3 as shown below.

       

      Table 3:

      StateChannelPackingProductValue1Value2Value1 + Value 2
      State1DealerBagProduct110010110
      State1DirectBulkProduct210020120
      State1DirectBagProduct210050150
      State2DealerBagProduct120050250
      State2DirectBulkProduct220050250

       

      Unable to understand how to approach this.

      Any help is very much appreciated.

       

       

      Regards