Forum Discussion
Resolver Imatrix display for heirarchy
I'm trying to display the heirarchy way to represent data, i have used path method , but im unable to display in visual
| ID | hirachy | name | parent ID | global name |
| 100 | Global | a | null | null |
| 101 | Global | b | null | null |
| 102 | intermediate | c | 101 | b |
| 103 | country | d | 102 | c |
| 104 | country | e | 105 | f |
| 105 | intermediate | f | 100 | a |
| 106 | intermediate | g | 105 | f |
want to display global ID and underneeth its heirarchy numbers.
In the matrix visual formatting pane go to Row headers and turn off stepped layout. That should give you the desired view.
9 Replies
- JirkaZ
Solution Specialist
You should just be able to put both columns (ID and Parent ID) into the same row field of the matrix visual. The hierarchy should be created automatically.
sanjanaramaJirkaZ
I'm not getting desired result
for example if i expand the matrix , it should look like this100 Global a 105 Intermediate f 106 intermediate g - JirkaZ
In that case create a separate "Level" columns for Level 1, Level 2, Level 3 using the output of the PATH function. For Level 1 you should use PATHITEM(yourpath, 1) etc.
Then you'll have to create a hirearchy in your table (right click on Level 1 and select Create Hierarchy. Then add L2 and L3 to the same hierarchy.Finally add this hierarchy to your matrix rows area.