how to convert table into hierarchy table in hana studio using sql script

[rizwana_khan1]

Hi All,

My requirement is to convert a table with fields like material,hierlevel1,leverl2,level3,level4,level5 into a hierarchy representation table in Hana studio using sqlscript .Could you please help

Thank you

[pfefferf]

For a detailed answer your question is to vague, maybe you can share some more details.

But I guess you are searching for the hierarchy generator function HIERARCHY_LEVELED which creates a hierarchy based on leveled source data; like your data is.