So I have two tables and want to return the rows where the tables dont match. But because of how the join tool works it adds more rows and thus gives me false negatives.
Table A
| ID | Warranty Coverage |
| A | Full |
| B | Part 1 |
| B | Part 2 |
| C | None |
Table B
| ID | Warranty Coverage |
| A | Full |
| B | Part 7 |
| B | Part 1 |
| C | None |
After Alteryx Join Tool and a formula tool to see if they match
| ID | Warranty Coverage Table A | Warranty Coverage Table B | Match |
| A | Full | Full | True |
| B | Part 1 | Part 7 | False |
| B | Part 1 | Part 1 | True |
| B | Part 2 | Part 7 | False |
| B | Part 2 | Part 1 | False |
| C | None | None | True |
As seen here ID 'B' really only had one mismatch(false) ; Part 2 =/= Part 7. Yet because of how join works it actually comes back as 3 False. Is there a way to compare these so that it only gives me the true mismatched ones(i.e avoid join creating repeated ID )
Thanks
