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
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 691 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive