Randomizing a field value

Reply
White Belt

Randomizing a field value

Is there a function or trick to randomizing a value when running a dataflow?  For example, I have 4 rows with a column value of ABC.  When running the dataflow, it should randomize that value to NVA across the four rows.  

Highlighted
Black Belt

i assume your use case is something along the lines of randomizing an employee name.

if you want all cases of 'ABC' to update to the same value 'NVA' you need to create an anonymization table that has a list of all the employee names and then the anonymized value that you changed it to.  

 

Then JOIN the anonymization table to the dataset and use the updated value.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
Stand out in the Dojo: Choose your own recognizable username and add a unique profile photo in your profile settings.