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 hour