Data comparison of customer orders from multiple years

• Comparing customer order data across different years for trend analysis
• Aggregating sales data to identify high-value customers
• Automating the process of data comparison to save time and reduce errors

Triggers the workflow manually to initiate data retrieval Executes SQL queries to fetch order data from specified years Aggregates order totals and counts for each customer Compares datasets to identify matches based on customer numbers and years Updates order count for matched datasets

1. 1
   Import the workflow template into n8n
2. 2
   Configure the MySQL database connection with your credentials
3. 3
   Adjust SQL queries if necessary to match your database schema
4. 4
   Manually trigger the workflow to execute the data comparison