parent and child loop in single table

[mrcl9933]

Hi,

I would like to create a visualization to show the relations between Origin to the latest id.

With the follow result in a visualization    : 1  > 2 > 3 > 4

                                                                                       5 > 6 > 7 > 8 > 9

I have thought about a sanky diagram but werent able to visualize it.

I hope anyone could help me out.

Example of my datatable:

Id	Parent_Id	Origin_Id	Text
1		1
2	1	1
3	2	1
4	3	1
5	4	1
6	5	1
7		7
8	7	7
9	8	7