How to Flatten the parent Child hierarchy where last level is not defined

[former_member812548]

I've tried self join but that approch degrading the performance as number of levels are 40.

Please help if we can use any another approach like in Oracle we can implement this by connect by

Input Table

Expected Output

[CharlesFeng]

Hi,

Please let me clarify, because it seems "SAP HANA Studio" is not the optimal tag for this query.
Are you going to implement it via SQL or other program languages?

Best regards,
Charles