5 Replies Latest reply: Mar 17, 2016 11:48 AM by Sunny Talwar RSS

    Mapping load and sum()

    Christian Seger

      Hi,

       

      i am searching for a solution which can map "Gewerk" and "Price" to the Table 2.

      I am using mapping load, but the Price did not sum. Can anybody help `?

       

      IS:

      Table1:

      Gewerk, Price, Work   
      Building,   150Roof
      Planning,   100Kitchen
      Building,     50TV

      Table2:

      Gewerk, PriceREAL,   PRICEFUTURE
      Buliding 350   400
      Planning   250   150

       

      Taget:

      Gewerk, PriceREAL,   PRICEFUTUREPrice_new
      Buliding,  350,   400,200
      Planning,   250,   150100

       

      Thanks

      C. Seger