Skip to Content
0
Former Member
Apr 10, 2016 at 07:16 AM

Nested table in hana by using Calc views

185 Views

I have a requirement to get data in the below format from hana, I have written a Calc view..but I am not sure how get to store the looping data (Awards, Wall of fame) by using Nested table. So that I can get the data in the below format. I am using Java Spring Framework to call the calc view.

Main table have to contain Awards and Wall of fame has nested tables.

{

"Name": "A",

"No": 89700,

"Awards": [

{

"Award_key": 1,

"Award_name": "Best Performer1"

},

{

"Award_key": 2,

"Award_name": "Best Performer2"

},

{

"Award_key": 3,

"Award_name": "Best Performer3"

}

],

"Wall_fame": [

{

"WF_key": 1,

"WF_name": "Best Performer1"

},

{

"WF_key": 2,

"WF_name": "Best Performer2"

}

]

}

Need help.