Add up a group_index for each ID in Dataset

daniel_foerster

Given following example set:

id;group_index

1

1

1

1

1

2

2

2

2

2

3

3

3

3

3

3

 

and i want the group index to be filled like:

id;group_index

1;1

1;2

1;3

1;4

1;5

2;1

2;2

2;3

2;4

3;1

3;2

3;3

3;4

 

How an i manage this? i tried loop values in combination with generate attributes but it's setting 1 for each ID or count up in one row.

 

 

Thank you!

MartinLiebig

Hi,

 

Group Into Collection + Loop Collection with Generate ID inside is at least one way of doing it.

 

BR,

Martin

BalazsBarany

Hi,

 

you could check out this project:

https://github.com/bbarany/rapidminer-windowfunctions

 

Your request is an application of window functions, available in relational databases. The project mentioned there implements these in RapidMiner. You can use this process, group by the id and use the row_number() function to get exactly the result you want.

 

Regards,

Balázs

hyukie

@mschmitz how i can group into collection and make loop collection
can u explain step by step

yyhuang

@hyukie, check out this https://community.rapidminer.com/discussion/57831/how-to-generate-id-for-below-scenario#latest