Using Filter table action
Use the Filter table action to filter data from a column in a table.
Procedure
- Double-click or drag the Filter table action from the Excel node in the Actions palette.
-
Specify the name of the table from which you want to filter data in the
Table name field.
Note: The table name is a string value. It is NOT a data table name. For information on how to retrieve the Excel table name, see Rename an Excel table.
- Select the Column name to specify the name of the column or the Column position to specify the position of the column that contains the data you want to filter.
-
Select the Number option if the column you have specified contains number data.
-
Select an option from the list to specify the operator you want to use to filter the data.
The following options are available:
- Equals: Filters the data that is equal to the value you have specified.
- Does not equal: Filters the data that is not equal to the value you have specified.
- Greater than: Filters the data that is greater than the value you have specified.
- Greater than or equal to: Filters the data that is greater than or equal to the value you have specified.
- Less than: Filters the data that is less than the value you have specified.
- Less than or equal to: Filters the data that is less than or equal to the value you have specified.
- Between: Filters the data that is between the two values you have specified.
Note: Apart from the Between option, you do not have to provide a value in the second field. If you have provided a value in the second field, the system ignores that value when filtering the data.
-
Select an option from the list to specify the operator you want to use to filter the data.
-
Select the Text option if the column you have specified contains textual data.
-
Select an option from the list to specify the operator you want to use to filter the data.
The following options are available:
- Equals: Filters the data that is equal to the value you have specified.
- Does not equal: Filters the data that is not equal to the value you have specified.
- Begins with: Filters the data that begins with the value you have specified.
- Ends with: Filters the data that ends with the value you have specified.
- Contains: Filters the data that contains the value you have specified.
- Does not contain: Filters the data that does not contain the value you have specified.
-
Select an option from the list to specify the operator you want to use to filter the data.
- Enter the name of the session used to open the workbook with the Open action.
- Click Save.