Merge node doesen't find source

Questions
4

Here’s the fix:

Before the Merge node, add a Set node on each input and create a new field called merge_key.

In the first input (PDF filename):

js

CopyEdit

{{ $json.name.replace('.pdf', '') }}

In the second input (DB data):

js

CopyEdit

{{ $json.AFJJ }}{{ $json.AFNR }}

Then in the Merge node:

  • Set mode to Combine
  • Turn “Fields to Match Have Different Names” OFF
  • Use merge_key as the matching field for both Input 1 and Input 2

This way the Merge node doesn’t need to evaluate any expression—it just compares static values.

Ask ChatGPT