Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Bold on a post-it! Thanks!