Select Columns Node

Description

Use the Select Columns node to choose a subset of columns from the input table. You can choose whether the selected columns are kept or excluded with the select mode dropdown.

Tips

• This node usually comes right after the Get Data node
• It is recommended to select the columns that are required in the new table
• Use the exclude parameter if you need to select a large number of columns or simply want to exclude a few number of columns from the output

SQL Equivalent

select {column_1}, {column_2} from {data_source}

↩️ Back to Workflow Settings

Updated on: 05/10/2024