Add Left- and Right-Anti-Joins to JOIN Tile in Magic ETL 2.0.

Ever need to isolate rows in Table A that are not in Table B or vice versa? Anti-Joins to the rescue! Except, there is not this option in the Join tile in Magic ETL 2.0. Instead, we have to use a formula tile with a Best Mode to set a comparison and tag rows and a filter tile to isolate the rows needed. Would be great if this could be added as an option in the Join tile itself. Please upvote if you think this would be helpful to you as well!
Comments
-
@Highland This would be nice. I do want to point out that there is a simpler way to accomplish this without the formula tile in current state. All you would need to do is have a filter after the join to only include rows where the join key from Table B is null. Hopefully that makes a slightly easier work-around in the meantime!
1 -
Oh! Oh! Add the ability to autodetect if a join is one to many or many to many too!
0 -
And also add cross joins -- making a column with a value of 1 on each table and then joining on that is a work around, would be nice to have as a feature.
1
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