Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Condensing MD5 Hash to shorter numeric key/ID


@jrgo @danilang 

Thank you both for the insights! 


I played around a little and came up with a test solution that produced zero duplicates with 105k uniques. It was an adaptation where I took the first 10 characters of the original 32 character hash and used the HexToInt function after splitting in to rows. After concatenating, I trimmed the integer to 19 characters, converted to INT64 with no issues and no duplicates. (workflow attached).


My metadata table will max out somewhere around 5-6k profiles that will need these unique values (they need to repeat year over year as we update the profiles to a new data year), so if it worked for 105k I feel confident it will work for a tenth of that.