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.  

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
New & Improved Dojo: Get excited for a new feel and additional features in the online community.

Site will be down February 4-5th for maintenance.

Launch coming February 8th!