Pivot

Pivot activity is used for pivot operations that will be done in an Excel file.


*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Source sheet	The Excel sheet name which includes data for the pivot is written.
Range	The information for the range to be pivoted is given.
Sheet name	The name of that sheet is given to show the result of the Pivot operation on a blank Excel sheet or a newly created Excel sheet.
Destination	It can be determined from which cell the pivoted data will be written in excel. Note: If no destination is given, the copy is made to cell A1.
Columns	It gives which columns will consist of in the pivot operation.
Rows	It gives which rows will consist of in the pivot operation.
Values	The desired action is written.

Note: * Fields selected with are required, others are optional.

Excel name example

You can use the Excel name as shown in the example.

${pivotExcel}

Source sheet example

You can use the Source sheet as shown in the example.

Sheet1

Range example

You can use the Range as shown in the example .

A1:B3

A:A

A:H

Sheet name example

You can use the Sheet name as shown in the example .

Pivot

Destination example

You can use the Destination as shown in the example .

A1

Columns examples

You can use the Columns as shown in the examples.

A

A,B

Rows example

You can use the Rows as shown in the example .

B

A,B

Values examples

You can use the Values as shown in the example s.

SUM(C)

COUNT(C),AVERAGE(C)

Supported functions:

AVERAGE

COUNT

COUNT_NUMS,

MAX

MIN

PRODUCT

STD_DEV

STD_DEVP

SUM

VAR

VARP

Note

If the first page of the excel files will be pivoted, the source sheet field does not have to be filled. Otherwise, it must be filled.

If no Destination is given, it is copied to cell A1.

If Range is not given, the entire range in the Excel file is taken.