Filter DataTable Window

Filters a given datatable

The Filter data table editor windows allow the user to filter the user-specified data table based on given filter criteria.

Filter DataTable Window

The filter data table window mainly contains 2 sections. One is the Filter input section for specifying the filter conditions and the other is the Preview section for displaying the output. The filter input section is divided into 6 columns for specifying the filtration criteria.

1. Column Name: In the first column, you'll find a drop-down list containing all the column names present in the input data table. Here, you can select the column on which you want to apply the filter.

2. Relational Operator: The second column provides a drop-down list of relational operators used for filtration. These operators allow you to define the relationship between the column value and the filter value.

3. Filter Value: The third column is where you specify the value to be used with the relational operator for filtration purposes. This value helps define the condition for filtering the data table.

4. Keep/Remove: The fourth column consists of a dropdown with options to either keep or remove the filtered records from the data table. You can choose the option that suits your filtering requirements.

5. Add Button (+): The fifth column contains a "+" button, which allows you to create a new filter condition in the editor window. You can add multiple filter conditions to fine-tune your data table filtration.

6. Remove Button (x): The sixth column consists of an "x" button, which allows you to remove a specific filter condition from the editor window. Use this button to remove any unnecessary or unwanted filter conditions.

Filter DataTable Window with filter conditions

To preview the filtered data table, click the "Preview" button. This will display the filtered results in a grid view below the filter section.

If you want to start fresh and remove all the filter conditions, you can use the "Clear" button located alongside the Preview button. This button clears or removes all the filter conditions, except for the default condition.

With the Filter Data Table Editor, you can filter and manipulate data tables based on your specific criteria, providing you with more control over your RPA processes.