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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Does anyone know a way to anonymizing data in Alteryx? I have unique identifiers that function as keys in my current DB. When I publish data to Tableau server I want to be able to change these IDs so they are usable in Tableau but revertable to IDs in my DB. Any ideas?
You could also introduce a random sort before assigning the ID in cases where the sequence might not already be random. Use a Formula tool to assign a Rand() value, sort by this, then assign the RecordID and go from there.
No matter what you will need a key generated to restore the IDs, which can be an output of the first workflow. A record id will give you a static key, while generating a random number will give you a more secure key, but is only good if the key is matched with the output from the same workflow run as the rand() function will generate a different number for a given record each time it is run. Also, be sure to match it with a record ID as rand() can generate the same number for two records.