Adding group ID to a result
Wojciech Glowacki
Contributor
in General
Hi,
I have an ID column I want to add a group/cluster ID column for them. So if they have the same ID they would have the same cluster ID. Would be grateful for a solution. Thanks!
0
Answers
-
Not sure I understand this. The records already have the same ID. Use a Transform to copy the column and rename it Group/ClusterID.
Is your challenge that unique records should not get a Group/ClusterID and should be blank?
0 -
-
There are previous similar discussions which should help using Sort then GetCell Function. If the IDs dont need to be in order then there are probably more performant ways to solve for larger datasets using RowNumber
0 -
An approach to solve if you have not come up with a solution:
- Group by Debitor (ID)
- Use Transform to add column containing the Row number
- Lookup against the original list to return the Row number as 'ID'
1 -
Thank you :)
0
