Mapping and sum()

[segerchr]

Hi,

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

Table1:

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

Table2:

Gewerk	PriceREAL	PRICEFUTURE
Buliding	350	400
Planning	250	150

Taget:

Gewerk,	PriceREAL,	PRICEFUTURE	PriceNEW
Buliding	350	400	200
Planning	250	150	100

The Target contains the distinct sum() of table1.

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

Thanks for helping.

CS

[sunny_talwar · Accepted solution]

Answered it here -> Mapping load and sum()