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.  

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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.