Select columns in a pipeline step

There are several methods using the mouse or keyboard to select columns for a pipeline step. When you edit settings for a transform step, use any of these methods to add columns to the Columns box.

  • In the transformation settings, click to expand the Columns list, and select the check box next to a each column that you want to transform. To clear a selection, clear the check box next to a column.
  • In the sample data table, click a column heading. To clear a selection, click the selected column heading.
  • In the Search box Image of Search box icon above the sample data table, choose Column, then type a column name in the adjacent Search box Image of Search icon. As you type, you can choose from matching columns displayed in a drop-down list.
    To clear the selection on a column, use the same procedure to specify a column name, then either click the Delete button Image of Delete button to clear the contents of the Search box, or use the keyboard to delete the contents of the Search box.