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
Add up a group_index for each ID in Dataset
daniel_foerster
Learner III
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!
0
Answers
Hi,
Group Into Collection + Loop Collection with Generate ID inside is at least one way of doing it.
BR,
Martin
Dortmund, Germany
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
can u explain step by step