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…
