Merge Node with Mode = 'Combine', and Output Type = 'Enrich Input X', not working as expected

[aballany]

Describe the problem/error/question

I have a Merge node that is not enriching the selected input as expected…

…and I have another that IS enriching the selected input as expected:

Can anyone explain why this is happening please?

Thanks!

What is the error message (if any)?

None

Information on your n8n setup

• n8n version: - self-hosted 1.64.3
• Database (default: SQLite): - default
• n8n EXECUTIONS_PROCESS setting (default: own, main): Don’t know
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Linux server running nginx.

[barn4k]

hello @aballany

I suppose the inputs don’t match at all because the fields companyID and companyId have different types (string vs number)

You should enable Fuzzy Compare option

[aballany]

So simple @barn4k! Thanks for your help.

[aballany]

I have another example of unexpected results from a Merge Node. This time it cannot be the data type of the match fields (they are both strings).

I’m enriching Input 1, so I would expect the ‘id’ column from Input 1 to be the first column in the output (in green in the screenshot), but it’s not, it’s taking the ‘id’ column from Input 2 as the first column! Why is this happening? Maybe you know @barn4k?

[aballany]

I solved the problem, I changed the name of the ‘id’ field in Input 1 so it differs from the identical field name ‘id’ in Input 2 and it now works. BUT surely the app should be able to distinguish between 2 identically titled fields in different inputs?