[rules-users] Drools fusion

[Wolfgang Laun]

You can match on hid but you'll have to write a sum using
value1+value2+value3 +value4.
-W

On 11/02/2014, Raja Sekhar <raja.amirapu at gmail.com> wrote:
> Sorry for the typo. I am looking for something like group by in a sql query
> where i can group by hid and sum up the values
> Is this something available .
>
> Regards,
> Raj
>
>
> On 11 February 2014 17:03, Wolfgang Laun <wolfgang.laun at gmail.com> wrote:
>
>> See below.
>>
>> On 11/02/2014, Raja Sekhar <raja.amirapu at gmail.com> wrote:
>> > Hi,
>> > I have values like this
>> >
>> > id hid value1 value2 value3 value4
>> > 1 1     100     100    100     100
>> > 2 1      100    100     100     100
>> > 3 2       150   150     150     150
>> > 4 2      150    150     150     150
>> >
>> > the end result should be e
>> > all hids with 1's should summed up
>> > all hids with 2's should summed up depends on so on
>> >
>> > i.e
>> >  valuessum1 valuesum2 valuesum3 valuesum4
>> >   200               200            200          200
>> >  200                 200            200          200
>>
>> A second line with "300 300 300 300" would make more sense.
>>
>> Expecting a feature to iterate over fields with names differing in a
>> suffix ordinal is a bit much. You can use Java's reflection or decide
>> on a data model where the valueN fields are stored in a List.
>>
>> -W
>>
>> >
>> > I did this with accumulate by comparing the hids and using the sum
>> function
>> >
>> > I looking for group by hid and sum l
>> >
>> > Regards,
>> > Raj
>> >
>> >
>> >
>> >
>> >
>> > On 11 February 2014 15:49, Wolfgang Laun <wolfgang.laun at gmail.com>
>> wrote:
>> >
>> >> On 11/02/2014, Raja Sekhar <raja.amirapu at gmail.com> wrote:
>> >> > Hi All,
>> >> > How can i perform aggregation on group with drools fusion.
>> >>
>> >> By performing all the necessary steps.
>> >>
>> >> A more detailed answer might be provided for a more detailed question.
>> >>
>> >> -W
>> >>
>> >> >
>> >> > Regards,
>> >> > Raja Sekhar A
>> >> >
>> >> > --
>> >> > Raja Sekhar Amirapu
>> >> > ------------------------------------------------------
>> >> > "If any anyone can do it, i can do it. If no one else can do it, i
>> must
>> >> do
>> >> > it"
>> >> >
>> >> _______________________________________________
>> >> rules-users mailing list
>> >> rules-users at lists.jboss.org
>> >> https://lists.jboss.org/mailman/listinfo/rules-users
>> >>
>> >
>> >
>> >
>> > --
>> > Raja Sekhar Amirapu
>> > ------------------------------------------------------
>> > "If any anyone can do it, i can do it. If no one else can do it, i must
>> do
>> > it"
>> >
>> _______________________________________________
>> rules-users mailing list
>> rules-users at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>
>
>
> --
> Raja Sekhar Amirapu
> ------------------------------------------------------
> "If any anyone can do it, i can do it. If no one else can do it, i must do
> it"
>