LogoLogo
About
Tables: v2
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
Tables: v2
  • Getting Started
    • Tables Overview
  • Table Creation
    • Create a Table
    • Create a Sample Table
    • Create a Pivot Table
    • Create an Integer Table
    • Create a Table from JSON
    • Create a Combined Table
    • Get a Table from a File
  • Rows
    • Get Rows
    • Get Row Count
    • Get Row Number
    • Get Value from Row
    • Insert a Row
    • Insert an Empty Row
    • Remove Duplicate Rows
    • Set a Row to JSON
  • Columns
    • Get a Column
    • Get a Column's Values
    • Get a Column Number
    • Get Column Count
    • Get Column Stats
    • Get Column Names
    • Change a Column's Data Type
    • Delete Columns
    • Insert a Column
    • Move a Column
    • Rename a Column
    • Rename Columns
    • Round a Column's Values
    • Update a Column
  • Cells
    • Set a Cell in a Table
  • Conversions
    • Convert CSV to a Table
    • Convert a Table to CSV
    • Convert a Table to Excel
  • Manipulations
    • Clear a Table
    • Combine Tables
    • Copy a Table
    • Extract a Subtable
    • Query a Table
    • Sort a Table
    • Replace a Value
    • Replace a Value in a Column
    • Transpose a Table
Powered by GitBook
On this page
  • Overview
  • Input Concepts
  • Output Concepts
  • Examples

Was this helpful?

Export as PDF
  1. Table Creation

Create a Pivot Table

Generates a pivot table from an existing table based on specified criteria.

Overview

This procedure generates a pivot table from an existing table based on specified criteria. Using a pivot table is a way to quickly summarize large amounts of data.

Input Concepts

Concept
Type
Description
Default
Required

table

table

The original table from which the pivot table will be created.

No default

Yes

row fields

strings

The columns to use as the indexes of the pivot table.

No default

Yes

column field

string

The column to use as the columns of the pivot table.

No default

Yes

value field

string

The column to use as the values of the pivot table.

No default

Yes

aggregation function

string

The function to aggregate the values in the pivot table. Valid options are sum, mean, and count.

No default

Yes

aggregate column name

string

The column name for the aggregated result in columns and row. Specified as: the aggregate column name is "column name"

No default

No

Output Concepts

Concept
Description

pivot table

The generated pivot table.

Examples

1. Example 1

For example, say we have a table defined in our automation as the sales data table.

Region
Product
Sales

North

Widget A

100

South

Widget B

250

East

Widget A

300

West

Widget B

450

the file
open the sales data table at the file
create a pivot table from the sales data table with
  the row fields are "Region"
  the column field is "Product"
  the value field is "Sales"
  the aggregation function is "sum"
  the aggregate column name is "Sales"
Region
Widget A
Widget B
Sales

East

300

0

300

North

100

0

100

South

0

250

250

West

0

450

450

Sales

400

700

1100

Last updated 21 days ago

Was this helpful?