The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Group & Sum items based on basketID

vagvalasvagvalas Member Posts: 1 Learner I
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



Tagged:

Answers

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