Assign a unique ID

[Shadi]

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:
Germany
USA
USA
England
England
How can I generate a unique ID for each (each USA should get a unique ID as well)?

Thanks

[iCFO]

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.

[mlauber71]

@Shadi you could use this component and create a UUID

GUID Generator – sjporter

Or use H2 or similar tools:

Example how to use H2 database with a uuid unique identifier – mlauber71

[takbb]

Continuing the GUID theme… adding the following to a String Manipulation node can do it too

string(java.util.UUID.randomUUID())

(although remembering a component is arguably easier than remembering that piece of code! )