Skip to Content
0
Nov 04, 2020 at 06:16 PM

need to convert array of objects to columns of table

21 Views

products :[

{

name :x

value:1

group1:1

},

{

name:y

value:2,

group3:3

},

{

name:z

value:3

group2:2

}

]

output:

SN group2_name group2_value group1_name group1_value group3_name group3_value

1 x 1 y 2 z 3



Hi I am having product array in JSON. i am using JSON_TABLE to convert products array objects to columns, but iam unable to do. please help input object and output shown above.

I need hana query