Assigning people based on the ZIP
Hello,
I'm coming with a following question. I'm working with inconsistent dataset. My Domo dataset has an individual assigned to a sale based on the ZIP within a region, which is incorrect. Within that region there is more than 1 person who sales there, that info is based on the ZIP code. I have the correct ZIP code file in excel with a proper person assigned to a proper ZIP code. How can I introduce those changes in Domo so that I can display different people's sales based on their ZIP code from the Excel file?
Thanks!
Answers
-
It sounds like you want to do a left join using either DataFusion/Blend or Magic ETL.
Based on your question, it's a little unclear what you want to keep from the first dataset and what you want to drop, but both options give you the ability to drop columns from either the left or right dataset.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 -
@DavidChurchman from my original domo set I want to drop the sales person name when the ZIP code from the excel I uploaded manually doesn't match the name of a person assigned to a correct ZIP, does that make sense?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive