What is the Pivot Feature?

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

A one-dimensional table is also often called a pipelined table. It usually has fixed column names. You can add data one row at a time.
A 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 results. Its information is more concentrated.

When to Use the Pivot Feature?

A two-dimensional table is more suitable for us to read. Its information is more concentrated, which is helpful in displaying analysis results.

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.

Note:

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

I have finished reading. 🏆

👉I can't wait to Try for myself.

👉I need more HELP in Discord Forum.