Select Columns
The Select Columns Step is used to select which columns should remain in a data block and remove columns that are no longer required.
Key Features
- Select Required Columns — Keep only the columns needed for further processing.
- Remove Unused Columns — Exclude unnecessary or irrelevant columns from the data block.
- Simplify Data Processing — Reduce the number of columns passed to subsequent transformation steps.
- Improve Performance — Processing fewer columns can reduce memory usage and improve transformation performance.
How to Use
- Add the Select Columns Step to the transformation.
- Select the columns you want to keep.
- Deselect or exclude columns that are not required.
- The selected columns are passed to the next transformation step.
This step is particularly useful when the source contains many columns but only a subset is required for the final output.
For more technologies supported by our ETL Software see
Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum
Posted on August 30, 2025
•
1 min read •
173 words