Through the Column Browser, you can use data quality bars and data type information to perform basic review of data across many columns. You can use these tools to select data of interest for display in the data grid or Column Details views or to prompt for suggestions of recipe steps.

Column Browser

You can select one or more columns in the browser and then perform actions on them.

Locate Columns

You can apply one or more filters to limit the set of columns displayed in the browser. Click the Filter icon in the Transformer toolbar.

NOTE: Filters are additive and persist between the column browser and the data grid.

For more information, see Filter Panel.

Select Columns

You can manually select one or more columns or apply one of the predefined selections.

  • To select a range of columns, click a column, press SHIFT and then click the ending column.
  • To select multiple discrete columns, press CTRL/COMMAND and click additional columns.
  • To toggle selection of a column, click it again.
  • You can copy and paste columns and column values. For more information, see Copy and Paste Columns.

Transformer Toolbar

At the top of the column browser, you can use the toolbar to quickly build common transformations, filter the display, and other operations.

For more information on the Target menu in the Transformer toolbar, see below.

See Transformer Toolbar.

Column Actions

For any individual column:

RapidTarget Matching

You can associate a target schema with a recipe. A target schema is information about the column names, data types, and order of the target dataset for which you are trying to build your recipe. For more information, see Overview of RapidTarget.

Actions taken based on the target schema are rendered as new steps in your recipe at the current location.

RapidTarget Panel in Column Browser

In the RapidTarget panel, a target schema that has been associated with your recipe is displayed as an extra set of columns on the left side:

SideDescription
LeftColumn from target
RightColumn from source (current recipe)

Schema Tags:

Between the two sets of fields are a set of tags that describe the matching between the two columns in the order listed in each dataset. Each tag describes the match found for the corresponding target or source column.

Tip: Mouse over tags that are not solid green to learn the nature of the column mismatch. You can then click the tag to insert steps in your recipe to match the two columns.

Match by NameMatch by Data TypeMatch by PositionIconDescription
No--Square - red outline

Target column has no identifiable name match in source. Column appears to be missing from source.

Tip: Click the source or target rectangle to manually assign a matching column.

YesNoNoSquare - blue outlineSource column name has a matching target column name, but it is in the incorrect location. 
YesYesNoSquare - green outlineSource column name and data type have a match in the target, but it is in a different position.
YesNoYesArrow - blue outlineSource column and target column match in name and position, but have different types.
YesYesYesArrow - green solidSource and target columns match in name, position, and type.

Target menu actions:

From the Transformer toolbar, you can select the following options from the Target menu:

When you have selected one or more source columns, you can additionally perform the following actions: