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
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 1 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 510 Automate
- 114 Apps
- 388 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive