Working with Transformer

Advanced ETL Processor transformer object transforms data from one format into another. There are 37  Transformation Functions available now for you to use right now  such as:

• String Transformation
• Number Transformation
• Date Transformation
• Multiple Date Formats
• Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
• Deriving a new calculated value (e.g., sale amount = qty * unit price)
• Joining together data from multiple fields
• Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
• Customised Transformations

Note:
 To change Transformer properties double click on it



Note:
If transformer is connected to any object other than writer it is possible to modify list of Outputs. When transformer is connected to writer list of Outputs is taken from the Writer.

Examples:

Example below splits date field into Day, Month and Year using ‘/’ as a delimiter




Another Example Converts Customer Name into More readable format:




Auto mapping

If the Inputs and Outputs have got the same names you may use Auto map feature.

Click , Fill in all necessary data and click map.

About Advanced ETL Processor

Advanced ETL Processor is a Codeless ETL Tool.
It is designed to automate extracting data from ANY database, transform, validate it and load into ANY database .

Users can create Data transformations and Sql scripts add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

Watch Online Flash Demo
Download Advaced ETL Processor now