Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
segerchr
Contributor III
Contributor III

Mapping and sum()

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

1 Solution

Accepted Solutions
1 Reply
sunny_talwar

Answered it here -> Mapping load and sum()