This example demonstrates how to create files using field value as part of the file name.

Download and install Advanced ETL Processor
https://www.etl-tools.com/advanced-etl-processor-enterprise/overview.html

1. Create a new transformation and open .ats file
2. Double click on the Reader object and amend source file path
3. Double click on the Writer object and amend target file path leaving the calculation intact
4. Double click on sorter and amend buffer path 
5. Press green arrow to run

Questions?
Ask them here
https://www.etl-tools.com/support/support-forum.html

https://www.etl-tools.com