Alteryx designer Discussions

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

Create a unique hash for every record




I have searched a lot of posts but couldn't find a decent solution.


We have a table with lots of address columns and other information. We want to create a unique hash for every row to prevent pre-processing. Even if one column address changes, the hash would be different. This hash will tell us if it is an old or a new record we are looking at. An example sheet is attached.


Is it possible to achieve this with Alteryx tools or should I look into Python packages to achieve this? Any help would be appreciated.


Thank you.

Alteryx Certified Partner

Hi @anishgrandhi 


The MD5_Hash function will do this for you. You can find this within the Formula tool. You'll probably want to create a single field that concatenates all your address information and then run the hash function.