Create a unique hash for every record

anishgrandhi

Hey,

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.

States table.xlsx

jamielaird

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.