Workflow 1: Merging data

[Sebas]

Describe the problem/error/question

Just impossible to get the merge to work. Unclear instructions.

What is the error message (if any)?

region and subregion are never added, merge outut is mostyl empty, only contains output when selecting ‘Keep everything’, but thats without the region. What am I missing here?

Please share your workflow

Share the output returned by the last node

The original Airtable table is shown when selecting Keep all, otherwise nothing happens

Information on your n8n setup

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

[hrishikesh]

Could you share an example output returned by the Airtable node and HTTP request node so we understand the nature of the data?

You can also pin the response so we can see that, just like you’ve done for the click node.

[Sebas]

Hi, yes see flow

[Sebas]

This seems to work, I created a Code Node version which does the job, as far as I can see. But if anyone can point to a working version with merge node, that would be appreciated

[hrishikesh]

There you go:

The output of edit fields is:

[Sebas]

Looks good. So it looks like we need the extra next step also ( Edit Fields Node ) to map region and subregion before updating with the AirtableNode.

[hrishikesh]

Edit Fields was not necessary. I just added it to simplify my output.