The function can be used when the institution code in the institution code table has two columns: the current institution number and the direct superior institution number.
Take the Bank Institution table as an example. The institution code JGID of the Bank of Jiang Dantu New District Branch is 7018, and its direct superior institution code PARENT_ID is 0711, which means that the Bank of Jiang Dantu New District Branch is directly subordinate to the Bank of Jiangyuan City Branch.
A hierarchical relationship helps classify various banks into different levels and make clear their hierarchical relationships, as shown in the following figure.
The function applies to a table with two columns of its own ID and parent ID. If the table only has one column that can be used to describe the hierarchical relationship, you can refer to Self-Looping Column (Hierarchy Based on One Columns of Data).
The Self-Looping Column function is available to basic tables and not supported for self-service datasets and direct-connected data tables.
1. Select the database BIdemo_Bank_Institution in Public Data, and click Edit, as shown in the following figure.
Field Description
2. You need to ensure that both ID columns for hierarchy building are text fields. If not, you need to convert their field types into Text, as shown in the following figure.
1. Click Self-Looping Column.
2. Set the conditions required for the self-looping column, and click Build Association.
4. FineBI automatically builds the hierarchical relationship of the bank, with a total of five levels. Modify their names to Head Office, First-level Branch, Second-level Branch, First-level Subbranch, and Second-level Subbranch, as shown in the following figure.
After updating the table, you can use the hierarchical fields generated by the self-looping columns to create self-service datasets and new dashboards.
For details, see section "Application Scenario."
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy