Hi, In my project i need to work on jSON file in excel. Here is jSON file structure ..
{
"id": "b9adce3c-2599-4b07-ac70-0d575a78b60e",
"type": 3,
"expression": "01_ABCD",
"aggregation": 0,
"caption": "COUNTRY_1",
"description": "",
"category": "GEOGRAPHY",
"operators": [
0,
5,
8,
9
],
"tables": [
"F_DOLLAR"
],
"format": "",
"hidden": false,
"cbattr": "",
"sensitiveFlag": false
},
My objective is to convert it in rows and columns in excel like this ..
I attached real json file here pls confirm how i can do this in excel. If we can do this through any command button that would be great.