Hi team, I’m looking to compare two datasets and find missing emails. Node 1 fetches clients and outputs their email address, this returns 158 results. Node 2 looks up the email addresses in Notion, this returns 120 results. I want to compare these two datasets to see which clients didn’t get found in Notion by comparing the email field for both datasets. In other words, which 38 clients didn’t get found in the Notion database.
I tried multiple things such as merge node and compare datasets, but they never output 38 results as you’d expect. In the screenshot you can see the merge node outputs a total of 94 items, which also includes emails that DID get found in Notion, so it’s not accurate. The settings in the merge node seem logical to me… compare the email fields and keep the non-matches, but it doesn’t work as I’d expect.
Any help would be much appreciated!
