ARCS Many to one rule : how to group by an attribute that is not in the rule — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!