Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Create a unique hash for every record

anishgrandhi
7 - Meteor

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.

1 REPLY 1
jamielaird
14 - Magnetar

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