How to create a Unique Identifier
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
baileyblough
6 - Meteoroid
‎08-16-2021
01:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Data Investigation
2 REPLIES 2
17 - Castor
‎08-16-2021
01:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sebastiaandb
12 - Quasar
‎08-16-2021
11:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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 :-).
