Compare 2 SQL datasets

Manual

Medium

Nodes

Manual

Trigger

Medium

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

manual Trigger

When clicking "Execute Workflow"

1 node

compare Datasets

Compare Datasets

1 node

my Sql

Orders from 2003 and 2004, Orders from 2004 and 2005

2 nodes

set

Change ordercount

1 node

Workflow JSON

3.84 KB

{
  "id": "emPRhyWgxygwHgWh",
  "meta": {
    "instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a"
  },
  "name": "Compare 2 SQL datasets",
  "tags": [],
  "nodes": [
    {
      "id": "df04c503-d4af-4e8f-bcc3-f1fd02d3a332",
      "name": "When clicking \"Execute Workflow\"",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        780,
        340
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6fe78ae6-7325-4062-ab58-457dc1d985c4",
      "name": "Compare Datasets",
      "type": "n8n-nodes-base.compareDatasets",
      "position": [
        1560,
        320
      ],
      "parameters": {
        "options": {
          "multipleMatches": "all"
        },
        "mergeByFields": {
          "values": [
            {
              "field1": "customerNumber",
              "field2": "customerNumber"
            },
            {
              "field1": "year",
              "field2": "year"
            }
     ...

Showing first 1000 characters. Click "Expand" to view the full JSON.