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

Data flow

Dynamically Create Excel file based on field value

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

Transformation

File name calculation

Note: Source changed function forces creation of new file  

File name calculation

Calculation inside the file name

Calculation inside file name

Please contact us if you need help with transforming the data

Visit ETL Tools Forum