This Example Demonstrates how to perform basic validation and transformation of a delimited file

Source Data

Here is a data example, it has two issues too many spaces between words and the first characters are not in upper case. we also want to process data only for 2004

Source Data

Steps to follow

  • Download and install Advanced ETL Processor [Link]
  • Download and Unzip example [Link]
  • Create a new transformation and open the .ats file

XML ETL Transformation

  • Select the reader object and select Customer_Sales.csv file
  • Double-click on the writer object and select Customer_Sales2.csv file
  • Press the green arrow to run the transformation

How it works

Data flows from the reader to the writer. The validator checks the year if it is not 2002 it rejects the record.

Validating Data

Transformer uses "Delete spaces transformation function" to get rid of additional spaces and "Proper case transformation function" to convert the first character to upper case.

Transforming data

Transformation result

Transformation result

Please contact us if you need help with transforming the data

Visit ETL Tools Forum