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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 650 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 752 Automate
- 187 Apps
- 477 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 140 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive