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
