This tutorial shows how to create one Excel file per source record in Advanced ETL Processor. Use it when each input row needs its own workbook, such as one customer file, invoice file, or department file per record.
What You Will Learn
- Create a separate Excel file for each source record.
- Build a dynamic Excel file name from source data.
- Use variables to detect when the output file should change.
- Send each record to the correct generated workbook.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Dynamic Excel File Output
This tutorial creates Excel files based on a source record field value. It uses a demo customer CSV file from github.com/datablist/sample-csv-files.
The supporting documentation covers creating a new Excel file and dynamic file names.
File Name Expression
file.{GetVariable('file_name')}.xlsxCalculation
begin
if GetVariable('file_name')<>[F001] then
SetVariable('file_name',[F001]);
SourceChanged;
Result:='test';
end;Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.