Top N by Grouped Fields

apabonok

Hi!  I'm new in Rapidminer.  With this set of data:

Country, Customer, Sales
----------  ------------- ------------
Country1, C, 100
Country1, B, 90
Country1, A, 80
Country1, D, 70
Country1, H, 60
Country2, X, 1000
Country2, P, 900
Country2, Z, 800
Country2, W, 700
Country2, M, 600


I want Top 3 of Customer by each Country. This:

Country, Customer, Sales
----------  ------------- ------------
Country1, C, 100
Country1, B, 90
Country1, A, 80
Country2, X, 1000
Country2, P, 900
Country2, Z, 800

Pls, help me. 

MartinLiebig

Hi,

Group Into Collection, Loop Collection and Filter Example Range should do the trick. Maybe check out this video: https://www.youtube.com/watch?v=7szR0HdDVRg for some quick explanation of Group Into Collection.

BR,

Martin

apabonok

Wonderful! Yes, that it works for me!!!!  Thank you!!!!