I have a sample data something like below. {
"Year": {
"Top30RequesterInOneYear": {
"Bob": 22,
"Marry": 12
},
"TotalRequestCountInOneYear": {
"9": "K",
"10": "C"
},
"Top10ActionInOneYear": {
"31": "update table",
"33": "Display log"
}
},
"Month": {
"Top30RequsterInOneMonth": {
"Foo": 3,
"Bob": 6
},
"TotalRequestCountInOneMonth": {
"1": "K",
"5": "C"
},
"Top10ActionInOneMonth": {
"10": "Display log",
"11": "update table"
}
},
"Week": {
"Top30RequesterInOneWeek": {
"Bob": 6
},
"TotalRequestCountInOneWeek": {
"15": "C"
},
"Top10ActionInOneWeek": {
"3": "update table",
"7": "display reboot"
}
}
} The output is expected is as below. Can someone please help me on this. Top30RequesterInOneYear Name | Count Bob 22 Marry 12 TotalRequestCountInOneYear Count | Status 9 K 10 C Top10ActionInOneYear Count | Action 31 update table 33 Display log Top30RequsterInOneMonth Name | Count Foo 3 Bob 6 TotalRequestCountInOneMonth Count | Status 1 K 6 C Top10ActionInOneMonth Count | Action 10 display log 11 update table Top30RequesterInOneWeek Name | Count Bob 6 TotalRequestCountInOneWeek Count | Status 15 C Top10ActionInOneWeek Count | Action 3 update table 7 display reboot
... View more