Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

Library / Reports, Analytics & Dashboards

Reports, Analytics & Dashboards

Compare Two SQL Datasets of Orders in MySQL

When you run it, it queries orders from two year ranges in MySQL, compares the datasets and updates the order count.

What it does

# Compare 2 SQL datasets ## Overview Automated workflow: Compare 2 SQL datasets. This workflow processes data and performs automated tasks. ## Workflow Details - Total Nodes: 6 - Node Types: 5 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - When clicking "Execute Workflow": manualTrigger - Compare Datasets: compareDatasets - Orders from 2003 and 2004: mySql - Orders from 2004 and 2005: mySql - Change ordercount: set - Workflow Documentation: stickyNote ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible

The steps

  1. When clicking "Execute Workflow"
  2. Compare Datasets
  3. Orders from 2003 and 2004
  4. Orders from 2004 and 2005
  5. Change ordercount
  6. Error Handler

Similar automations