Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Distinct Applymap

Dear All,

I got a mapping Table with 'Object Number' and 'Order Income':

Map_OrderIncome:

mapping load Distinct

Object.Number,

Order.Income

Resident

CE1;

this should be mapped to the Facttable

Fact:

load

*,

  ApplyMap('Map_OrderIncome',Object.Number,'') as Order.Income //

Resident

Fact_temp;

The result is as follows:

Sales Number     Object Number    (i.e.)  Document Number     Order Income

1234                    1234_1                         123456789                    1.000

1234                    1234_2                         123456788                    1.000

1234                    1234_2                         123456788                    1.000

...

But the result should be

Sales Number     Object Number    (i.e.)  Document Number     Order Income

1234                    1234_1                         123456789                    1.000

1234                    1234_2                         123456788                    1.000

1234                    1234_2                         123456788                       -

...

I want to have just one record per Object Number in my Table. Is this possible?

Thanks in advance

Lukas

10 Replies
Anonymous
Not applicable
Author

Bold on a post-it! Thanks!