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

Highland

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!

MichelleH

@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!