This example demonstrates how to create files using field value as part of the file name.
Data flow
To view the example follow the steps below
- Download and install Advanced ETL Processor [Link]
- Download and Unzip example[Link]
- Create a new transformation and open the .ats file
- Double-click on the Reader object and amend the source file path
- Double-click on the Writer object and amend the target file path leaving the calculation intact
- Double-click on the sorter and amend the buffer path
- Run the transformation by pressing the green arrow.
Transformation
File name calculation
Note: Source changed function forces creation of new file
Calculation inside the file name
Please contact us if you need help with transforming the data
Visit ETL Tools Forum |