Login
Updated on January 21, 2025

FilterTable

Estimated reading: 4 minutes 2034 views

This activity can be used to filter a “specific value” either by restricting or excluding the “Rows or columns” from the “Input datatable.”

Properties

INPUT

ColumnFilterMode: It gets auto filled once the option is selected in the “Filter Wizard” window. Select the options from the drop-down to filter the “column.”
Keep: It enables to display only the specified “Column and its values”.
Remove: It enables to remove only the specified “Column value” from the table.

InDatatable:* Enter the “Input datatable” variable where the input data is stored. This parameter helps you to filter the “Rows/ Columns” from the table. This field only accepts the “datatable” data type.

RowFilterMode: It gets auto filled once the option is selected in the “Filter Wizard” window. Select the options from the drop-down to filter the row.
Keep: It enables to display only the specified “Row and its values.”
Remove: It enables to remove only the specified “Row value” from the table.

MISC

Display Name: Displays the name of the activity. It can also customize the activity name to helps in troubleshooting.

FilterRowQuery: It gets auto filled once the “Row’s values” are specified in the filter wizard box. It indicates “Query” to the filter the rows from the table. This field accepts only “String” datatype. When left blank, it will throw an exception to provide the “RowQuery” if either the “Rows” or “Columns” are not specified.

SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False”. By default, it is set to “False.”
True: Continues the workflow to the next step
False: The workflow aborts if it throws any error.
None: If the option is specified as blank, by default the activity will perform as “False” action.

Version: It specifies the version of the Datatable automation feature in use

OUTPUT

OutDatatable:* It helps to view the output of the activity after filtering the rows and columns in a “Datatable” datatype. (Refer the steps below to create a variable)

*Represents Mandatory field to execute the workflow

Filter Wizard

1. Drag and drop the “Filter” activity from the Datatable Automation.
2. Double click on the activity and choose the “Filter wizard” option. 
3. The filter wizard will have two tabs such as “Filter rows” and “Limit columns”.
a. Limit columns:
    i. It enables column filtering, either restricting the view to specified columns or excluding specified columns from the table. This tab has two options,
    ii.  Keep – This option displays only the specified columns.
   iii. Remove– This option eliminates the specified columns. 
   iv. Specify the “Column” name from the “Input Datatable”. Multiple columns can be filtered by choosing the “+” button to add more columns from the table.
   v.  Select either to keep or remove the columns.
   vi. Once done, click on “OK” button.

b. Filter Rows: It enables row filtering, either restricting the view to specified rows or excluding the specified rows from the table.
     i. This tab has two options,
    ii. Keep – This option displays only the specified rows.
c. Remove– This option eliminates the specified rows.
i. Specify the “Column” name from the “Input Datatable”.

Operations available in Filter wizard:

  1. Choose the operation from the drop-down.
  2. < : It validates to check whether the provided “ColumnName” is lesser than the specified “RowValue”.
  3. >: It validates to check whether the provided “ColumnName” is greater than the specified  “RowValue”.
  4. <= : It validates to check whether the provided “ColumnName” is lesser than or equal to the specified “RowValue”.
  5. >= : It validates to check whether the provided “ColumnName” is greater than or equal to the specified “RowValue”.
  6. = : It validates to check whether the provided “ColumnName” is equal to the specified “RowValue”.
  7. != : It validates to check whether the provided “ColumnName” is not equal to the specified “RowValue”.
  8. IsEmpty: It validates to check whether the provided “ColumnName” is empty.
  9. IsNotEMPTY: It validates to check whether the provided “ColumnName” is not empty.
  10. StartsWith: It validates to check whether the provided “ColumnName” starts with the specified value.
  11. EndsWith: It validates to check whether the provided “ColumnName” ends with the specified value.
  12. Contains: It validates to check whether the provided “ColumnName” contains with the specified value.
  13. DoesNotStartwith: It validates to check whether the provided “ColumnName” does not starts with the specified value.
  14. DoesNotEndWith: It validates to check whether the provided “ColumnName” does not ends with the specified value.
  15. DoesNotContain: It validates to check whether the provided “ColumnName” does not contains the specified value.
    i.  Multiple columns can be filtered by choosing the “+” button to add more columns from the table.
    ii. Select either to keep or remove the columns.
    iii.Once done, click on “OK” button.
DatatableAutomation - Previous DatatableToHtmlFile Next - DatatableAutomation JoinDatatable

Recently Viewed articles

Share this Doc

FilterTable

Or copy link

CONTENTS