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.
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.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 368 Beast Mode
- 19 Variables
- 483 Automate
- 101 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive