Using Filter table action

Use the Filter table action to filter data from a column in a table.

1. Double-click or drag the Filter table action from the Excel node in the Actions palette.
2. 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.
3. 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.
4. Select the Number option if the column you have specified contains number data.
   1. 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.
5. Select the Text option if the column you have specified contains textual data.
   1. 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.
6. Enter the name of the session used to open the workbook with the Open action.
7. Click Save.