Pivot - Jodoo - Documents

Pivot

Introduction

Pivot can transfer one-dimensional tables into two-dimensional tables:

One-dimensional table is also often called pipeline table. It usually has fixed column names. You can add data one row at a time.
Two-dimensional table is a kind of relational table. The values in data areas need to be determined simultaneously through rows and columns. This kind of table is more suitable for reading and displaying analysis result. Its information is more concentrated.

Two-dimensional table is more suitable for us to read. Its information is more concentrated, which is helpful to display analysis result.

Here is an example of displaying students' subject scores:

Go to App Management > Data Factory > New Data Stream.

Rename the data stream, click Input, and add the Examples form as the data source.

Add Pivot and connect the input node with the pivot node.

The configuration of the pivot is as follows:

Configurations	Definition	Example
Grouping Field	It supports grouping the repeated data. You can set multiple grouping fields and change their names.	Select Name in the Examples form.
Column Field	It is the row header of the pivot. You can set only 1 column field. Supported Fields: Line type: Single Line, Radio, Single Select, Serial.No., and Extended field. Number type: Number.	Select the Subject in the Examples form and tick all subjects.
Value Field	It is the value after grouping. You can set only 1 value field. The supported grouping way is as follows: Number type: Sum, AVG, Max, Min, Count, and Dedupe. Other types(Line, Time, Member, Department, etc): Count, Dedupe.	Select the Scores in the Examples form and select grouping ways as Sum.

Click Data Preview to see the effect.

Connect the pivot node with the output node, rename the output node, and click Save.

For details about the effect, see the section"Preview".

At most 50 pivot nodes can be added to one data stream.