反馈已提交
网络繁忙
FineBI Version
Functional Change
6.0.3
/
Column to Row refers to converting a two-dimensional table to a one-dimensional table.
A one-dimensional table is also commonly referred to as a pipeline table, which has fixed column names. You just need to add data row by row.
A two-dimensional table is a kind of relational table, in which the value needs to be determined by both rows and columns.
Regarding data relationships, the two-dimensional table has a clear feature: Some fields in the column have the same nature. However, every field in the one-dimensional table is unique.
For example, the following figure shows a two-dimensional table: City Consumption and Expenditure.
1. After the sample table is converted to a one-dimensional table, each column in the table is an independent dimension, which is more suitable for data analysis. For example, after the table City Consumption and Expenditure is added to a new dataset and processed, the data in the columns Consumption Amount and Expenditure Amount are displayed row by row.
2. Drag the processed data in a group table. The following figure shows the data effect.
Edit data in an analysis subject and use the Column to Row function.
You can download the sample data: City Consumption and Expenditure.xlsx.
Upload the sample data to an analysis subject. Go to the data editing interface of the City Consumption and Expenditure table.
1. Choose More > Column to Row.
2. Merge the columns Consumption Amount and Expenditure Amount. Select these two fields.
For the effect, see section "Expected Effect."
feedback
鼠标选中内容,快速反馈问题
鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。
不再提示
10s后关闭