The select node is used to connect a single table to a data source node. Unlike the Multi-Select node, many Select nodes can be connected to a single data source, with each node representing a different table. A range of operations and functions can then be connected to any given Select node in order to perform any required data cleansing or manipulation on the data set before loading it into a target.

Select nodes are a good option if your data set contains tables on which you need to perform any kind of data preparation; the alternative to the Select node is the Multi Select node, which does not support data cleansing processes in the Data Flow.

Configure Select Nodes

There are 2 methods of adding Select nodes to the Data Flow.

Method 1

The first method is to select all the required tables from the Properties panel of the data source node, and then click 'Add Select Nodes' (green highlight below):

You will see that each selected table will now be represented by its own Select node:

Method 2

The second method requires you to add each Select node individually, connecting them to the data source node (green arrow below), and to then inject the relevant table (blue arrow) into each Select node from the Properties panel. You can also rename the table from each node (red highlight).

Edit Select Nodes

To edit a Select node, click on it and go to its Properties panel. Here you can update the node's preview and its various settings.

You can rename the table (red highlight below), change the table selection (green highlight), change the column selection (yellow highlight), set incremental loading via a variable, and add a description that will be visible only in the Model app.