Options

Group & Sum items based on basketID

vagvalasvagvalas Member Posts: 1 Newbie
edited January 2022 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

  • Options
    ceaperezceaperez Member Posts: 525 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.