This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.