Compares 2 sets of data with an IF node

Questions
1

I have 2 sets of data.
Set 1 - Data from a MySQL Database
Set 2 - Data from an HTTP Response. (getting parsed with a code node)

If “company_name” from Set 1 is in Set 2, True, if not, false.
If True, we can update the company. If false we have to add the company to the list.

I’ve tried to put both data in the “if” node and it keeps throwing a Missing pairedItem data (node ‘CODE’ probably didn’t supply it)

I’ve tried to use the compare node, but that i think does a direct compare and not filter though?

Any ideas on how i can achieve this would be fantastic!

N8N version: Latest
database: Default
Running on docker.

2

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:
3

@paulyy , you can use Merge nodes instead if the sets are not fully comparable.