Filtering out the same rows and different rows in Alteryx

[smodu398]

Hey, so I have two excel sheets and I want to find rows that are exactly the same from column A-E and rows that are different in any column. How would I go about doing this. 

[cjaneczko]

Have you tried using the Join Tool? The J anchor will show all matches. The R and L anchors will show mis matches. 

[smodu398]

Yea I have, would using the join tool and joining by every column header do the job? I was not sure if the join method would check if one of those is equal or if every field I add has to be true to join. 

[griffinwelsh]

@smodu398 The join tool outputs to the J anchor only when all fields are matches.

[smodu398]

I tried the join tool and chose every column header and it seems to be giving more than what I am looking for. Any other ways I could go about this.