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 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.
Pivot Table Name: *Specify a name for the pivot table to be created. This parameter accepts input in the String data type.
Range: *Provide the “Range” to create a pivot table in the destination sheet. This parameter accepts values in the String data type.
Source Sheet Name: * Specify the sheet name from which the pivot table should be referenced and created, it accepts the inputs in the String datatype.
Source Table Name: *Specify the table name from which the pivot table should be referenced and created, it accepts the inputs in the String datatype.
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