1 Reply Latest reply: Mar 16, 2016 4:36 PM by Sunny Talwar RSS

    Mapping and sum()

    Christian Seger

      Hi,

       

      i need a solution to map a distinct datafiled to another table.

       

      Table1:

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

       

      Table2:

      Gewerk PriceREAL  PRICEFUTURE
      Buliding  350400
      Planning   250150

       

      Taget:

       

      Gewerk, PriceREAL,   PRICEFUTUREPriceNEW
      Buliding  350400200
      Planning   250150100

       

      The Target contains the distinct sum() of table1.

      How can I map the distinct data of Table1 to Table 2 ?

       

      Thanks for helping.

      CS