This tutorial shows how to perform Conditional Excel Column Transformation in Advanced ETL Processor. Use it as a practical step before building larger automated ETL workflows.
What You Will Learn
- Follow the steps to perform Conditional Excel Column Transformation.
- Understand where this task fits in Advanced ETL Processor.
- Avoid common setup mistakes before using the object in production work.
- Prepare for the next tutorial in the Advanced ETL Processor sequence.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Tutorial Notes
This video was inspired by a forum post from one of our customers.
The question
- I read a column from my reader (input).
- When the value is not null (string), load the data into the designated writer field.
- When the value is null (empty string), load the data from another input field.
This can be easily achieved by using "If Null transformation function"
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.