Hello every one,
Is there a way to generate a unique ID to each value that exist in another column?
I have Column A that contains the followings:
How can I generate a unique ID for each (each USA should get a unique ID as well)?
You can use the Duplicate Row Filter followed by the Counter Generation node to assign Unique IDs, then Join it back to the table to apply them to the wider dataset.
@Shadi you could use this component and create a UUID
Or use H2 or similar tools:
Continuing the GUID theme… adding the following to a String Manipulation node can do it too
(although remembering a component is arguably easier than remembering that piece of code! )
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.