Dynamic Select Tool
Use Dynamic Select to select (or de-select) columns either by column type or by using a formula. Dynamic or unknown columns are also selected by column type or formula at runtime.
Configure the Tool
Choose the mode for column selection:
By Data Type: Check the column data types to add them to your selection. Columns containing these data types pass through the tool.
Using a Formula: Enter a formula into the expression editor to select columns that pass through the tool.