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 <[email protected]> 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 <[email protected]> wrote: > >> See below. >> >> On 11/02/2014, Raja Sekhar <[email protected]> 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 <[email protected]> >> wrote: >> > >> >> On 11/02/2014, Raja Sekhar <[email protected]> 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 >> >> [email protected] >> >> 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 >> [email protected] >> 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 [email protected] https://lists.jboss.org/mailman/listinfo/rules-users
