Pivot

User interface

General Principles Add Missing Dates Add text column Add Total Rows Aggregate Append Compare Text Columns Argmax Argmin Concatenate columns Convert Convert date to text Convert text to date Cumulated sum Custom step Delete column(s) Geographically dissolve data Duplicate Duration Evolution Extract date information Extract substring Fill null Filter Formula Geographical hierarchy Get unique groups/values Hierarchical rollup ifthenelse Join Keep column(s) Moving Average Percentage Pivot Rank Rename Replace Geographical simplification Sort Split column Column's Statistics To lowercase To uppercase Top N rows Unpivot Waterfall

Technical documentation

Packages Steps Designing a new step Known limitations Variables UI components Custom code editor Python package

Pivot column

You can use this step if you need to transform rows into columns. It is the reverse operation of an unpivot step.

Pivoting a column into several columns means that every unique label found in that column becomes a column header. The column gets pivoted “around” fixed columns that you can specify. You also need to specify a value column where values will be found to fill pivoted columns. If aggregation needs to be performed, you can choose the aggregation function (sum by default).

Equivalent to the PIVOT clause in SQL.

This step is supported by the following backends:

Mongo 5.0
Mongo 4.2
Mongo 4.0
Mongo 3.6

Where to find this step?

Widget Reshape
Search bar

Options reference

Keep columns...: the columns to remain fixed, around which the pivot will occur
Pivot column...: the column to be pivoted
Use values in...: the columns where values are found to fill the pivoted columns
Aggregate values using...: the aggregation function to be used when aggregation has to be performed
Pivot values in ...: for sql translator only, values to keep in value column

Example

This configuration results in: