- Documentation
- Activities
- Data
- Filter table
Keep only rows that match certain conditions
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Table Variable tableName | variable | Required | — | — |
Filter Conditions filterConditions | array | Required | — | List of filter conditions with column, operator, and value |
Combine Conditions With logicalOperator | enum | Optional | AND | —ANDOR |
Output Variable outputVariable | variable | Optional | filteredTable | — |
Output
filteredTableDataTableFiltered data table
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Add table column
Add a new column to an existing data table
Add table row
Add a new row to a table
Clear table
Remove all rows from a data table
Convert table to text
Turn table data into a text format like CSV
Create table
Create a new table to store rows and columns of data
Remove duplicate rows
Remove duplicate rows from a data table