Advanced ETL Processor handles complex transformations by keeping the work visual: Readers provide input fields, the Transformer maps and changes values, and Writers define the final output. Use this pattern when a transformation has hundreds of fields, repeated rules, lookups, date fixes, or format changes. At that size, the main problem is not power. It is keeping the map readable enough for Monday morning.
What You Will Learn
- Organise large Transformer mappings before adding more rules.
- Use Auto Mapping where source and target fields line up.
- Apply transformation functions without hiding the business logic.
- Preview records and check the previous step log when the grid is empty.
Before You Start
Use representative sample data, not just the first five friendly rows. Complex transformations usually fail on the row that looks like it was exported by a committee.
Complex Transformation Docs
The Transformer documentation explains how Advanced ETL Processor changes data format, structure, and values inside a transformation.
Use the Transformer Toolbar when working with large mappings. The toolbar includes object alignment, mapping print preview, source-data preview, record navigation, search, and processing controls.
Use Auto Mapping to reduce manual links when field names already match. Then review the result manually, because automatic mapping is helpful, not clairvoyant.
The examples show common changes such as splitting dates and reformatting names. For larger transformations, combine those patterns with Transformation Functions.
For function details, use the dedicated docs for strings, numbers, dates, lookups, JSON, and regular expressions.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.