Compare Two SQL Datasets from MySQL

This workflow automates the comparison of two datasets extracted from a MySQL payments table using custom SQL queries. One query aggregates orders from 2003-2004 by customerNumber and year, while the second covers 2004-2005 with an additional manipulation on the ordercount field. The Compare Datasets node merges them by customerNumber and year, producing four outputs: records unique to dataset A, unique to B, matching records, and records with differences.

Ideal for data analysts, it saves hours of manual spreadsheet comparisons by highlighting discrepancies automatically. Benefits include rapid data validation, audit trails for financial reports, and quality checks on aggregated summaries.

Use cases span financial reconciliation (e.g., payment trends), sales reporting across periods, inventory audits, or any scenario needing side-by-side SQL result analysis. Compatible with the MySQL sample database from mysqltutorial.org for testing.