Merge Node is not working as it is getting Undefined on Input2

Questions
1

I’m trying to get Merge Combine by Matching Fields with Keep Non-matches to get a list of new items to work from a combination of a HTTP request and a google sheet… it has been working until yerterday. Input 2 is showing the field data as undefined… If I disconnect Input 1 from the node, the Merge node can find the Input 2 data…. but if I reconnect Input 1 into the Merge node, the Input 2 field gets undefined again, thus the merge node does not have data to compare.

image
image1089×770 117 KB

What is the error message (if any)?

Please share your workflow

Information on your n8n setup

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

If the problem is with Input 2, could you pin it too?

3

not allowing me to upload the full pinned flow….

An error occurred: Sorry, new users can only put 5 links in a post.

4

Merge is using field to match. Not value

Screenshot_20251004_161941_ME4akbwf@2x
Screenshot_20251004_161941_ME4akbwf@2x1454×1000 49.8 KB

The expected Field should be key

While your expression is represent value and it will cause Merge not working.

If the value like Company name have some different like upper case or format.

You need to convert the format before Merge node.

5

both field types are Text.. do you have any suggestion to normalize formats?

6

maybe put a set field node before merge. And normalize in set field first.