Anonymize a column of data
I would love to be able to convert or transform a column of data to anonymize it. For example, I have a clients data set that we use all the time but I would also like to be able to have the client column have a replica column where all the names are converted or anonymized. This way I can use the same data but keep the identity and client names private as needed. Any ideas on how to edit a column or the data in this way?
Search: anonymous, anonymized, encrypted, converted
Comments
-
What I have done when I need to anonymize names like this is create an Excel file that contains the client's real name and then another column that has a fake name. In my case, I needed to change last names, so I googled most popular last names, copied the list from the table and pasted it into my Excel file next to the real last names. I then uploaded the file and joined it in the ETL and used the Select Columns to use the fake name as the new last name.
This may not be feasible for you if you have thousands and thousands of clients, but thought I would suggest it.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 688 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive