Distinct Applymap

[Anonymous]

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

[Anonymous]

Bold on a post-it! Thanks!