Pivot
Introduction
Functions
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.
Application Scenarios
Two-dimensional table is more suitable for us to read. Its information is more concentrated, which is helpful to display analysis result.
Preview
Here is an example of displaying students' subject scores:
Setting Procedure
Creating Data Streams
Go to App Management > Data Factory > New Data Stream.
Selecting Data Sources
Rename the data stream, click Input, and add the Examples form as the data source.
Adding a Pivot
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:
| 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:
| Select the Scores in the Examples form and select grouping ways as Sum. |
Click Data Preview to see the effect.
Saving
Connect the pivot node with the output node, rename the output node, and click Save.
Demonstration
For details about the effect, see the section"Preview".
Note
At most 50 pivot nodes can be added to one data stream.