Skip to main content

Filter Pivot Table

Creates a filter in a pivot table based on the values in a single column. Can also be used to clear existing filters.

Input​

  • Table Name: Pivot table to filter on
    • Type: System.String
    • Required
  • Column Name: The column to filter on
    • Type: System.String
    • Required
  • Clear Existing Filters: elect this option if you want to clear existing filters instead of creating a new one. Clearing filters does not remove filter configurations from inside the activity, if any were defined.
    • Type: System.Boolean
    • Required

Details​

  • This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.