Removing Matching Rows

[stav]

Hello,

I'm having a hard time figuring out how to remove matching rows between two tables. I've tired the merge function but it only keeps rows that match between the two tables. Is there a way to merge two tables but only keep values that don't match in both? I have one query that only shows dates for from the last month and another query that shows the previous 2 months. After merging I only want to show what the dates that didn't match.

Example:

Table A:                     Table B:               After Merging--->          Table C:

CreateDate                 CreateDate                                             CreateDate

6/1/17                       7/1/17                                                    6/1/17

6/15/17                     7/15/17                                                   6/15/17

7/1/17                       8/1/17

7/15/17                     8/15/17

8/1/17

8/15/17

[Greg_Deckler · Accepted solution]

You need to change your Join Kind at the bottom of the Merge interface to be a Left or Right Anti.

Check out the documentation on Table.NestedJoin

https://msdn.microsoft.com/en-us/library/mt260794.aspx

[stav]

Thank you so much!