Merge Node Showcase
detail.loadingPreview
Demonstrates various merging strategies using the n8n Merge node, mimicking SQL JOIN and UNION ALL operations.
About This Workflow
This workflow illustrates the power and flexibility of the n8n Merge node. It showcases how to combine data from different sources, analogous to SQL join operations (INNER JOIN, LEFT JOIN) and UNION ALL. The examples cover merging ingredients with their required quantities, filtering ingredients in stock, and combining datasets of musicians into a 'super band'.
Key Features
- Data Aggregation: Combine data from multiple sources into a single dataset.
- SQL Join Emulation: Mimic INNER JOIN and LEFT JOIN operations for data matching and enrichment.
- SQL UNION ALL Emulation: Combine datasets, even with differing structures.
- Configurable Merging: Flexible options for defining merge criteria and modes.
How To Use
- Trigger: Click the
Execute Workflowbutton to run the workflow. - Explore Nodes: Double-click on each node (especially the
Mergenodes andCodenodes) to inspect their input and output data.A. Ingredients NeededandB. Ingredients in stock: TheseCodenodes provide initial data for ingredient matching.Ingredients in stock from recipe: ThisMergenode demonstrates an INNER JOIN like behavior, keeping only ingredients that are both needed and in stock. Connects toA. Ingredients NeededandB. Ingredients in stock.A. IngredientsandB. Recipe quantities: TheseCodenodes provide data for merging ingredients with their respective quantities.Merge recipe: ThisMergenode showcases a LEFT JOIN like behavior (enrichInput1), enriching the 'Ingredients' with 'Recipe quantities' where a match exists. Connects toA. IngredientsandB. Recipe quantities.A. QueenandB. Led Zeppelin: TheseCodenodes provide datasets for two different bands.Super Band: ThisMergenode demonstrates a UNION ALL like behavior, combining members from both bands into a single list, accommodating differing fields.
Apps Used
Workflow JSON
{
"id": "1a4bd9e2-2be8-4a5d-a4d0-fbc40541a33c",
"name": "Merge Node Showcase",
"nodes": 19,
"category": "Data Management",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 1a4bd9e2-2be8...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
FileMaker Data Entry and Update
Workflow to create a record in FileMaker, then edit it with additional data.
Dynamically Create Airtable Tables for Webflow Form Submissions
Automatically create dedicated Airtable tables for each Webflow form and log submissions.
CSV to MySQL Data Ingestion
Reads a CSV file and inserts its data into a MySQL database.