Create Pivot Table

This activity enables users to create a pivot table from a designated table in a specified Excel sheet. It must be used within the ‘Excel Scope’ activity.

Properties

INPUT 

Destination Cell: Specify the exact cell location in the destination sheet where the pivot table should be placed. This parameter accepts input in the String data type (for example, “A1” or “B5”).

Destination Sheet Name: Specify the “Sheet name” where the pivot table should be created from the source table. This parameter accepts input in the String data type.

Layout: Specify the display format of the pivot table by selecting a layout option from the dropdown.
a. Compact Layout: Shows multiple row fields in a single column with indentation to represent hierarchy and save space.
b. Tabular Layout: Displays each row field in its own column, creating a clear table format for analysis.
c. Outline Layout: Displays row fields in separate columns and groups related data together, with subtotals shown for each group.

Overwrite Table Name: Select this checkbox to overwrite an existing pivot table with the same name in the destination sheet. When selected, the existing pivot table is replaced; when cleared, the existing pivot table is retained.

Pivot Table Name: Specify a name for the pivot table to be created. This parameter accepts input in the String data type.

Source Range: Provide the data “Range” from the source sheet to create the pivot table. This parameter accepts values in the String data type (for example, “A1:D100”).

Source Sheet Name: Specify the sheet name from which the pivot table should be created. This parameter accepts input in the String data type.

Values Added As: Specify how the values should be displayed in the pivot table by selecting an option from the dropdown (Columns or Rows).

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow