Filter Data

Filters can be applied to Data Components through the Filter Table.

Activity Steps

  1. Click the Data Component in the Project Tree.
  2. Click on the Configure the Filter and Data Tab at the bottom of the Main Canvas.

    The Filter Table displays at the top of the Main Canvas.

  3. To activate a filter in the table, check Use for the relevant row.
  4. Select the Column Name from the available options. These are determined by the data you uploaded.
  5. Select how to Compare the data from the table below.

    OperatorFunction
    =Equal to.
    !=Not equal to.
    >Greater than.
    >=Greater than or equal to.
    <Less than.
    <=Less than or equal to.
    INAny values in a comma delimited list. For example, entering a condition of 1,2,3 would match any value that is 1, 2 or 3.
    NOT INAny value that is not in the comma delimited list. For example, entering a condition of 4,5,6 would match any value that is not 4, 5 or 6.
    LIKE

    Any value that matches the conditional pattern with these characters:

    • ? – Any single character. For example, entering a condition of LIKE "??0" would match any value of 3 characters and ending with a zero.
    • * – Zero or more characters. For example, entering a condition of LIKE "D*" would match any column value that starts with a "D".
    • # – Any single digit (0-9). For example, entering a condition of LIKE "###*" means match any value that starts with 3 digits.
    NOT LIKEAny value that does not match the conditional pattern. See examples for LIKE
    RegExAny value that matches the conditional "regular expression".

    Note: Regular expressions are very powerful patterns that can be very complex. Using regular expressions is only recommended if you have a good understanding of how they work.

  6. Enter the Condition relative to the chosen Compare operator.
  7. If required, enter a Comment.
  8. Apply the filter in one of the following ways.
    1. Right-click the row of the filter in the Filter Table and select Apply Filter or Reload Data from the menu. The option that displays depends on the type of Data Component you apply the filter to.
    2. Click Apply Filter or Reload Data in the Filter and Data tab.