Merge Node Showcase

Name: Merge Node Showcase
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

19 nodes connected

detail.loadingPreview

Free N8N Temples

84 views

0 downloads

Data Managementdata aggregationjoinmergesqlunion

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 Workflow button to run the workflow.
Explore Nodes: Double-click on each node (especially the Merge nodes and Code nodes) to inspect their input and output data.
- A. Ingredients Needed and B. Ingredients in stock: These Code nodes provide initial data for ingredient matching.
- Ingredients in stock from recipe: This Merge node demonstrates an INNER JOIN like behavior, keeping only ingredients that are both needed and in stock. Connects to A. Ingredients Needed and B. Ingredients in stock.
- A. Ingredients and B. Recipe quantities: These Code nodes provide data for merging ingredients with their respective quantities.
- Merge recipe: This Merge node showcases a LEFT JOIN like behavior (enrichInput1), enriching the 'Ingredients' with 'Recipe quantities' where a match exists. Connects to A. Ingredients and B. Recipe quantities.
- A. Queen and B. Led Zeppelin: These Code nodes provide datasets for two different bands.
- Super Band: This Merge node demonstrates a UNION ALL like behavior, combining members from both bands into a single list, accommodating differing fields.

Apps Used

data aggregation

join

merge

sql

union

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.