Hi all, i have the json data as below.
{
"Info":
{
"Unit": "ABC",
"Project": "XYZ",
"Analysis Summary": {
"DB 1":{"available": "1088kB","use...
See more...
Hi all, i have the json data as below.
{
"Info":
{
"Unit": "ABC",
"Project": "XYZ",
"Analysis Summary": {
"DB 1":{"available": "1088kB","used": "172.8kB","used%": "15.88%","status":"OK"},
"DB2 2":{"available": "4096KB","used": "1582.07kB","used%": "38.62%","status":"OK"},
"DB3 3":{"available": "128KB","used": "0","used%": "0%","status":"OK"},
"DB4 4":{"available": "16500KB","used": "6696.0KB","used%": "40.58%","status":"OK"},
"DB5 5":{"available": "22000KB","used": "9800.0KB","used%": "44.55%","status":"OK"}
}
}}
I want to create a table like this
Database available used used% status
DB1 4096KB 1582.07kB 38.62% OK
DB2 1088kB 172.8kB 15.88% OK
DB3 16500KB 6696.0KB 40.58% OK
DB4 22000KB 9800.0KB 44.55% OK
DB5 128KB 0 0% OK
I know how to extract the data but i am not able to put data in this format in table. Anyone have idea on this?