Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Answered it here -> Mapping load and sum()
Answered it here -> Mapping load and sum()