UuidCreate() -- defining parameters for the unique identifier

OmaratRJL

Hello

I have the following use case I need to define a 6 character identifier for about 1.2 million records. Using the UuidCreate() gives me something that looks like this: 

d24eca0a-50c1-4a09-8e09-783abff272a1

I am 100% that this will insure uniqueness but it needs to be usable and this is way too long. So I was wondering if there is a way to get Alteryx to trim the string while the function is working and also do some extra things like: 

eliminate the letters o, i ,l to increase readability and accuracy. 

If I trim the string to 6 characters I get roughly 36,000 dupes.

Any ideas on how to tackle this?

jdunkerley79

While not guaranteed to be unique, how about:

IntToHex(RandInt(HexToNumber("FFFFFFFF")))

This will generate a random hex number of up to 8 characters long

The chance of collision will be high at this level, if you allow 12 then it will be much lower.

An alternative approach would be to randomly order the records and add a record ID. This would guarentee uniqueness