Generating tree-like hierarchy from a flattened table

[kundan_ghosh]

I have a hierarchy of Id that are flattened into a table structure, as per the attachment. Each Id (except for topmost node) has a ParentId

For example, 5a287a7bfc13ae4ab60003fa has parent 5a287a7bfc13ae4ab600042f but subsequently 5a287a7bfc13ae4ab60003fa is itself represented under ParentId column with its child nodes mentioned under Id column

Can someone suggest how to transform this structure into a Qlik tree-like hierarchy

[Anil_Babu_Samineni · Accepted solution]

May be look?