Advanced ETL Processor can handle changing source layouts with the Fields Order transformation object. It lets you define the field sequence the transformation should use, so files or tables with reordered columns can still produce consistent output.
What You Will Learn
- Add a Fields Order object to a transformation.
- Define the expected output order for incoming fields.
- Protect downstream steps from reordered source columns.
- Use the object when source files or tables change structure regularly.
Before You Start
Test with at least two source samples that contain the same fields in different orders. One perfect sample proves very little, which is why production data waits patiently to disagree with it.
Fields Order Docs
The Fields Order documentation explains how the transformation object reorganises fields into a defined sequence.
Use Fields Order properties to set the field order used by the transformation. This keeps the output stable even when the original source order changes.
The usage example shows the same fields arriving as A-B and B-A, then being normalised to the same order inside the transformation editor.
Use this object when source files or source tables are unstable, especially when new fields are inserted inside the source or the source table structure is reordered regularly.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.