Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to create a Unique Identifier

baileyblough
6 - Meteoroid

Is there a tool within Alteryx to create a unique identifier for a record? We are running into a issue where we need to tie unique identifiers to each line of data; however, are unable to come up with a way to create one. We have tried concatenating fields into one field to create a unique identifier but our data set is constantly changing and are unable to pull in something unique enough were we will not have duplicates.  

 

Is there a tool that could create a random set of letters/numbers? 

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @baileyblough,  

 

Did youtried record id tool? I think you can use it as identifier.

Sebastiaandb
12 - Quasar

@baileyblough Here you go (see example). You can utilize the transpose and sigma tool to create a unique hash for every row, it's dynamic in that if you create extra columns it will all end up in the same hash :-). 

Labels