Excel - upload jSON file and apply customization

Occasional Contributor

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 ..

TheTallman_0-1625594617846.png

 

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.

 

0 Replies