Hi everyone,
I’m a novice with n8n, however, I am certain there is an issue with the way a merge node is handling my data.
Describe the problem/error/question
My Merge node is set to combine 2 inputs by Matching Fields. The Field to Match has identical name in both inputs. Output type is Enrich Input 1. The two fields from input 2 I expect to be added to input 1 are present, one is displaying the correct data, but the other is displaying NULL for all items. This should not be happening.
What is the error message (if any)?
No error message
Please share your workflow
Need some guidance on this!
Information on your n8n setup
- n8n version: - self-hosted 1.64.3
- Database (default: SQLite): - default
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
- Operating system: Linux server running nginx.
Welcome to the community @aballany !
Tip for sharing information
Pasting your n8n workflow
Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.
```
<your workflow>
```
That implies to any JSON output you would like to share with us.
Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!
The actual examples of data you merge would help to understand why it is not working.
Here’s the demo of the workflow and I encountered no issue you described:
The matching items get enriched as expected.
Hi and thanks for responding. On further inspection this issue is me!! There were NULLS in the data that I didn’t pick up on.
However, I have another issue with a merge node - when enriching one input with another, I’m not getting the additional data joined on. Here’s the example:
My expectation is the output looks like this:
| Column 1 |
Column 2 |
Column 3 |
| dealId (input 1) |
companyId (input 1) |
companyName (input 2) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I have this working in other merge nodes, but not this one. Very confused!
I should add, I have exported the data from input 1 and 2 to csv, and then joined them in Excel, and it works exactly as I expect.
Here is the example @ihortom where the merge node IS joining the additional fields as I would expect:
Why is this working and my other example is not?
I would assume something to do with how the data is fed into the Merge node in those examples.
