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