Compare Sql Datasets

About This Script

Features:

• Automates workflow tasks
• Ready to import into n8n
• Configurable parameters

{
    "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"
                        }
                    ]
                }
            },
            "typeVersion": 2.3
        },
        {
            "id": "0dae008c-242d-4757-a5a4-a075bde54cb6",
            "name": "Orders from 2003 and 2004",
            "type": "n8n-nodes-base.mySql",
            "position": [
                1080,
                220
            ],
            "parameters": {
                "query": "SELECT customerNumber, SUM(amount) as Total, COUNT(*) as ordercount, YEAR(paymentDate) as year\nFROM payments\nWHERE YEAR(paymentDate) = '2003' OR YEAR(paymentDate) = '2004'\nGROUP BY customerNumber, year\n;",
                "options": [],
                "operation": "executeQuery"
            },
            "credentials": {
                "mySql": {
                    "id": "EEPqCgKBDiRRZ3ua",
                    "name": "db4free MySQL"
                }
            },
            "typeVersion": 2.1
        },
        {
            "id": "c162e9b5-6e26-4a81-b90d-a5709e73019c",
            "name": "Orders from 2004 and 2005",
            "type": "n8n-nodes-base.mySql",
            "position": [
                1080,
                440
            ],
            "parameters": {
                "query": "SELECT customerNumber, SUM(amount) as Total, COUNT(*) as ordercount, YEAR(paymentDate) as year\nFROM payments\nWHERE YEAR(paymentDate) = '2004' OR YEAR(paymentDate) = '2005'\nGROUP BY customerNumber, year\n;",
                "options": [],
                "operation": "executeQuery"
            },
            "credentials": {
                "mySql": {
                    "id": "EEPqCgKBDiRRZ3ua",
                    "name": "db4free MySQL"
                }
            },
            "typeVersion": 2.1
        },
        {
            "id": "05547a67-2c53-43df-8abd-ee356f12742b",
            "name": "Change ordercount",
            "type": "n8n-nodes-base.set",
            "position": [
                1300,
                440
            ],
            "parameters": {
                "values": {
                    "number": [
                        {
                            "name": "ordercount",
                            "value": 1
                        }
                    ]
                },
                "options": []
            },
            "typeVersion": 2
        }
    ],
    "connections": {
        "Change ordercount": {
            "main": [
                [
                    {
                        "node": "Compare Datasets",
                        "type": "main",
                        "index": 1
                    }
                ]
            ]
        },
        "Orders from 2003 and 2004": {
            "main": [
                [
                    {
                        "node": "Compare Datasets",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "Orders from 2004 and 2005": {
            "main": [
                [
                    {
                        "node": "Change ordercount",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        },
        "When clicking \"Execute Workflow\"": {
            "main": [
                [
                    {
                        "node": "Orders from 2003 and 2004",
                        "type": "main",
                        "index": 0
                    },
                    {
                        "node": "Orders from 2004 and 2005",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements