Group & Sum items based on basketID

vagvalas

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

Caperez

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

aggregation.rmp