Orange Forum • View topic - need ur help pls to group and sum

need ur help pls to group and sum

A place to ask questions about methods in Orange and how they are used and other general support.

need ur help pls to group and sum

Postby giladbi » Thu Oct 18, 2012 7:40

pls c attached screen cap. https://picasaweb.google.com/106321075253128446682/Orange_canvas?authuser=0&feat=directlink
i am trying to import a big csv file (1.8 mil lines/240 mb) and to group "profit" by "date" and by "setting"
i will appreciate any help!
thanks

Re: need ur help pls to group and sum

Postby Ales » Thu Oct 18, 2012 10:14

You need to move the rest of the attributes (except for 'date' and 'setting' to the Aggregate box (use 'First' aggregation if you don't really care for them) or remove them before the 'Group By' widget using the 'Select Attributes' widget.

Re: need ur help pls to group and sum

Postby giladbi » Thu Oct 18, 2012 11:13

i just tried to do this and got an error
pls check new pic at https://picasaweb.google.com/1063210752 ... directlink

btw, could i join all the table back after the grouping? i have a few

thanks


Return to Questions & Support