Apply Row Filter

Filter the specified data table.

The Apply Row Filter activity allows you to keep or remove rows from a DataTable based on specified filter conditions.

Input

• Input : DataTable Variable Specifies the DataTable that is to be filtered.

Configure

• Filters :

  This property allows you to define the filter conditions to be applied to the DataTable. You can use variables as filter values in the filter conditions. Make sure to prefix variables with '$' when adding them to the filter condition.

  

  Filter DataTable window

Information :

• The '+' button is used to create a new filter condition in the filter window.

• The 'x' button is used to remove a filter condition from the window.

• Each condition requires a column name, operator, and value to filter the DataTable.

• Variables can be represented as $VarName.

• There is a dropdown with options to either keep or remove the filtered records from the DataTable.

• The 'Preview' button displays the filtered DataTable in the grid below the filter conditions.

• The 'Clear' button removes all filter conditions except the default condition.

Output

• Output: DataTable Variable The variable that stores the resultant filtered data table.

By utilizing the Apply Row Filter activity effectively, you can easily filter rows in a DataTable based on specified conditions, allowing you to extract and work with the relevant data in your automation process.