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

anonymizing or hashing data to tableau server

JohnMaty
9 - Comet

HI all,

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? 

5 REPLIES 5
danilang
19 - Altair
19 - Altair

Hi @JohnMaty 

 

The problem with, and actually the Raison d'etre, of most hashing algorithms is that they're designed to be one-way.  String A gives hash value B, but given hash B you can't recreate String A.  That's where encryption algorithms come in.  They can both encrypt and decrypt data.  They can also be difficult to implement.  Luckily, @Ned, one of the founders of Alteryx, has a post where he shows how to encrypt data using a key.  He also provided the workflow that does it.

 

Dan

JohnMaty
9 - Comet

Thanks I will be checking that out.  I figured hashing was not feasible or logical here but thought, "hey, this is Alteryx, someone might have a 'thing'"

danilang
19 - Altair
19 - Altair

Hi @JohnMaty 

 

If you're willing to take an approach where you push fake IDs to Tableau and store a mapping table somewhere else, you can use this to generate the anonymous ids

 

danilang_1-1585912444188.png

 

Get the list of unique IDs and use a RecordID to generate a String key for each ID.  Join back to the input data, giving you something like this to send to Tableau

 

danilang_0-1585912411030.png

 

The mapping table looks like this 

 

m.png

 

Dan

 

 

JohnMaty
9 - Comet

This is EXACTLY the approach I am currently taking so it is reassuring that an ACE agrees.  I think this will meet the needs of our department.  Thank you for the insight!

danilang
19 - Altair
19 - Altair

My pleasure, @JohnMaty.  Just always keep mind the second half of the "Great minds think alike" saying;)

 

Dan

Labels