ARCS Many to one rule : how to group by an attribute that is not in the rule
We want to prioritize a match to be done by summarizing amounts based on an attribute on the source system only.
I explain :
in the source system we have
Amount | station | shiftID | date |
---|---|---|---|
100 | A | 123 | 01-JAN |
70 | A | 123 | 02-JAN |
70 | A | 444 | 02-JAN |
and the sub system
Amount | Station | shiftID | date |
---|---|---|---|
170 | A | Unknown | 03-JAN |
The rule is : Many to One:
date : tolerance of +- 7 days, same amount, same station
As the shiftID is unknown in the sub system we can't put it in the rule, but we want the match to be calculated first for the same shiftID of the source system.
Is it possible to do that?