How to pass through only the items that do no exista

Hey I have an issue, I’m getting information, then I want to add this information to a spreadsheet in airtable, but I want to add only the new rows.

I’m trying to filter Get all data–> Get the Airtable Records–> Continue only with the records that don’t exist.

The second issue is that in Airtable when I select “Return All” I get X 100 more items than I have. I have 32 and it returns 3200

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Update I kinda figured a solution

This is the second time I run the same data so there should not be anything that goes past the compare node, however there are still 10 that go through.

Hey @Vasislav , when using Compare Datasets node you have to make sure the two sets have exactly the same properties. If they differ, then all the items will be considered different. You might want to use Set node after one or both nodes to makes sure the sets you are to compare have the items with exactly the same property names and their number.

Alternatively use the Options to skip the fields you do not want to be included in comparasion.

1 Like

Hi @ihortom thank you for the reply I will try the fields to skip comparing.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.