Group & Sum items based on basketID

vagvalasvagvalas Member Posts: 1 Newbie
edited January 25 in Help
Hi to community,

This is my first post here.

I want to sum the unique products ab-15 (1 +1 ) as quantity,
but i want to sum products included in each basketID

so to output 13151   ab-15     2
                    13151   ab-24     3
etc...
                    13152   ab-15     1
                    13152   ab-17     3



Answers

  • ceaperezceaperez Member Posts: 321 Unicorn
    Hi @vagvalas
    Welcome to Rapidminer Community.
    In this case you are looking for the Aggregate operator, located in Blending->Table->Grouping.
    You can create complex rules of aggregation for your data with this operator. 
    In your case,  If you want to aggregate by product you need to open the aggregation attibutes window inside the operator and select Product as aggregation attibute and count in agregation function. 
    please find attached a simple process for that
    I hope this helps.

    Best, 
    Cesar
Sign In or Register to comment.