Check if site exists in another dataset, then remove from list if exists - ETL

Hi, I have a list of sites which have been joined from two datasets in an ETL using a field called 'Database Number'. This is working as expected.
I want to then check whether this 'Database Number' exists in dataset 3, if it does, it means that we are working on this deal and therefore don't need this included in the list. Is there a way for me to check if a site already exists in a dataset and then remove from the list?
I tried using a full outer join but that just showed a list of sites that do exist in the dataset, which is the opposite of what I'm trying to achieve.
Hopefully this makes sense but let me know if any additional information is needed!
Thankyou in advance.
Best Answer
-
Hi @louiswatson
You can do a left join from your existing dataset to your dataset 3 based on the Database Number. If the right table's Database Number is NULL then it doesn't exist in the left table. You can do a left join (or right join) and then filter on a NULL value.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Hi @louiswatson
You can do a left join from your existing dataset to your dataset 3 based on the Database Number. If the right table's Database Number is NULL then it doesn't exist in the left table. You can do a left join (or right join) and then filter on a NULL value.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
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