Alteryx designer Discussions

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

Create a unique hash for every record

Highlighted

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.

Highlighted
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.

Labels