9.10.3 Common Tasks

This topic describes common task to be performed in the data pipelines.

Configuring Filters

Users can configure a filter by defining various filter conditions. For more information on defining conditions, see Defining Filter Conditions.

To configure a filter, follow these steps:
  1. Navigate to the Output pane.
  2. Click Add corresponding to the Output pane to open the filter group. The filter group opens where you can add filter conditions.
  3. Click Add in the Output pane to create a filter condition. The filter condition is displayed.
  4. Define the filter condition. For more information, see Defining Filter Conditions.
  5. Click Include to include the filter in the widget. The filter is included and is functional in the widget.
  6. Click Save to save the changes. The filter is created. The entire expression that is formed as part of filter creation is displayed in the Output pane.

Defining Filter Conditions

You can define the filter conditions using one of the following:
  • Expression Builder
  • Tables
  • Text

Defining Filter Condition Using Expression Builder

You can form filter conditions using all the operators given in the Expression Builder. The Expression Builder is used to define free flow text filter conditions.

To define a filter condition using the Expression Builder, follow these steps:
  1. Click Exp. The Expression Builder dialog box is displayed.
  2. Select the required Dataset, Attribute, and Runtime Parameters and operators. The resulting condition is displayed in the Condition field.
  3. Click Save to save the changes.

Defining Filter Condition Using Tables

You can define filter conditions using the various columns of tables. The columns of the two tables are compared with each other using the required operators.

To define filter conditions using tables, follow these steps:
  1. Click Tables.
  2. Select the dataset or risk indicator and column on the left-hand and right-hand sides, and then select the operator.

Defining Filter Condition Using Text

You can define filter conditions using text. A particular column in a table is compared with the input text using the required operators.

To define filter conditions using text, follow these steps:
  1. Click Text.
  2. Select a dataset and column on the left-hand side, operator, and then enter the text in the field on the right-hand side.
  3. Click Save to save the changes.