1.It is an easy to transform with Hierarchical Data stage json format like this
{""menuitem": [
{"value": "New", "onclick": "CreateNewDoc()"},
{"value": "Open", "onclick": "OpenDoc()"},
{"value": "Close", "onclick": "CloseDoc()"}
}
2,But how to transform json file below (like an array) that return Goggle analytics for example
"columnHeaders": [
{ "name": "ga:source", "columnType": "DIMENSION", "dataType": "STRING" },
{"name": "ga:users", "columnType": "METRIC", "dataType": "INTEGER" }
["107.138.1.111:4081", "2"],
["107.138.771.111", "32"],
["17.138.727.222","1"],
------------------------------
Andrew Corck
------------------------------
#DataIntegration