Overview
Version
| FineBI Version | Functional Change |
6.0 | / |
Application Scenarios
The Row to Column function can change a one-dimensional table into a two-dimensional table.
One-dimensional table, also known as the pipeline table, has fixed column names. You just need to add data row by row.
Two-dimensional table is a relational table in which the values in data areas are determined by rows and columns. This table is suitable for displaying analysis results as it is more in line with people's reading habits with denser information.
One-dimensional table
Two-dimensional table
Note:Functions
Only base tables of extracted data support the Row to Column function in this document.
Generate new table header columns based on the field value of a certain field.
Procedures
Importing Data
1. Example data: Student Score.xlsx
2. Select a folder in Public Data and upload the downloaded example data.
After uploading, preview this one-dimensional table and click Edit.
Changing Row and Column
1. Tick the required fields and add the Row and Column Conversion step.
2. Go to the following interface.
①: Generate red area fields, similar to grouping fields.
②: Generate headers of new fields based on the field values of this column. Select the Subject field to generate the required new columns (Biology, Physics, and Maths).
③: The indicator field is ultimately filled in the orange area.
④: Click Preview Data.
3. After saving and exiting the editing interface, modify the field name in the preview interface.
The final effect is the same as section "Application Scenarios".
Notes
The system will automatically interrupt the row to column conversion when the result exceeds 500 columns.
If the number of new columns is more than 500 after changing rows to columns, this meaningless row-to-column operation may cause great pressure on the system, leading to memory explosion.
A prompt pops up: INTERNAL: aggregate function limit 500, input function size 677 is too many.
Previous：Defining Parameters when Adding SQL Datasets
