[rules-users] Many to many matching using Drools rules

[Wolfgang Laun]

You can collect objects of both classes with matching id and date.
Each of these collected objects has the original id and date a list of
amount figures.

Pairing the collected object from repository and accounting is simple.
Then, you'll have to implement an algorith that selects the items from
both sides in an acceptable way. I presume that one or more items from
one side must exactly be equal to one or more items from the other
side, which may not always be possible even though there would be
"coverage" of an item of one side by items on the other side (e.g.
7,11 vs.3,3,3,3).

But assuming that you detect matching sums, you retract the original
facts. In any case, the collected objects must be retracted, too, at
the end of the processing.

(Some details depend on the way the original facts are inserted.)

HTH
-W






On 14/12/2011, Zhuo LI <milanello1998 at gmail.com> wrote:
> i want to find txns from both sides whose portfolio asset and sum of amt
> are the same.
>
> 在 2011-12-14 上午9:18，"Salaboy" <salaboy at gmail.com>写道：
>
>> Do you want to compare to set of transactions to find which of them are in
>> both sets and which of them are not?
>> Is that what are you trying to achieve?
>> Cheers
>>
>> - CTO @ http://www.plugtree.com
>> - MyJourney @ http://salaboy.wordpress.com
>> - Co-Founder @ http://www.jbug.com.ar
>> - Mauricio "Salaboy" Salatino -
>>
>> On 13/12/2011, at 10:27, Wolfgang Laun <wolfgang.laun at gmail.com> wrote:
>>
>> > Huh?
>> > -W
>> >
>> > 2011/12/13 Zhuo Li <milanello1998 at gmail.com>:
>> >> Folks,
>> >>
>> >>
>> >>
>> >> I am recently working on a BI project which is doing reconciliation
>> between
>> >> repository and accounting. I'm using Drools 5.1.1 to maintain all these
>> >> matching rules. One scenario I have no clue to implement in Drools is
>> that I
>> >> need to find x transactions from repository, to match y transactions
>> from
>> >> accounting, while existing repository transactions and accounting
>> >> transactions are bigger than x and y. Does anybody have experience to
>> >> do
>> >> similar thing in Drools?
>> >>
>> >>
>> >>
>> >> Best Abe
>> >>
>> >>
>> >> _______________________________________________
>> >> rules-users mailing list
>> >> rules-users at lists.jboss.org
>> >> https://lists.jboss.org/mailman/listinfo/rules-users
>> >>
>> > _______________________________________________
>> > rules-users mailing list
>> > rules-users at lists.jboss.org
>> > https://lists.jboss.org/mailman/listinfo/rules-users
>>
>> _______________________________________________
>> rules-users mailing list
>> rules-users at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>