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.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"