This tutorial shows how to split an Excel file based on the current date using Validator in Advanced ETL Processor. Use it when date-based rows need to be routed into separate Excel outputs automatically.
What You Will Learn
- Use Validator logic to route rows by date.
- Split Excel data into date-based output files.
- Write routed rows into Excel sheets, tables, or ranges.
- Avoid manual workbook sorting when the current date changes.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Excel Writer Docs
This tutorial uses Validator logic to decide which Excel output should receive each row. Date-based workbook splitting is useful when the file structure is stable but the reporting date keeps moving. Excel dates do enjoy pretending to be simple.
The supporting Excel Writer documentation covers working with Excel sheets, Excel tables, Excel ranges, creating a new Excel file, adding data into an existing Excel file, and Excel Writer notes.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.