table data convert into nested json in hana

[Former Member]

Hi experts,

How to convert below table data into json format using sql or xsjs or sapui5

Table format:

Json format should be

[BenedictV]

More details on what your are trying to achieve by this and what you have tried so far, including any errors you have faced, will help the community members better help you.