value mapper not working
I'm trying to use the value mapper to change the names of sales agents in a cloumn in an attempt to gather them under a general title. For example I want "Sales Agent - John Smith" changed to " Inside Sales Rep". The problem I'm having is that the Value Mapper is working for some, but not others. I've triple-checked the mapping rules and it isn't a typo causing the issue. Here's an example of a value it is not working for : Agent Unassigned,
But, it is working on values like "CMH Sales - Pat Murphy"
Any help would be appreciated.
Comments
-
Do the values that fail to map all have characters like that comma in them?
If so you might be able to do something like the below. Possibly use a Replace Text option using the RegEx check box and replace the comma with empty string. Then it may process your value mapping correctly.
If that doesn't work, perhaps you could give a few more examples of the working and non-working values and we may be able to better tell what's going on.
Hope this helps,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive