{
"Region": "Asia Pacific",
"Office": "Australia",
"Location": [
{
"name": "Brisbane",
"Latitude": "-27.4690555",
"Longitude": "153.0286812",
"OfficeAddress": "Suite 4, L20 10 Eagle Street,Brisbane, Queensland, 4000,Australia"
},
{
"name": "Canberra",
"Latitude": "-35.3084798",
"Longitude": "149.1304273",
"OfficeAddress": "Unit 8, Level 2, 11 National Circuit,Barton, ACT, 2600,Australia"
},
{
"name": "Melbourne",
"Latitude": "-37.814090",
"Longitude": "144.970970",
"OfficeAddress": "Level 31, South Tower,80 Collins Street,Melbourne, Victoria 3000,Australia"
},
{
"name": "Perth",
"Latitude": "-31.9556291",
"Longitude": "115.8533297",
"OfficeAddress": "Suite 4.02, Level 4,1 William St,Perth, Western Australia, 6000,Australia"
},
{
"name": "Sydney",
"Latitude": "-33.86488",
"Longitude": "151.21192",
"OfficeAddress": "88 Phillip Street, 35th Floor,,Sydney, New South Wales, 2000,Australia"
},
{
"name": "Sydney - Experience Studio",
"Latitude": "-33.86488",
"Longitude": "151.21192",
"OfficeAddress": "88 Phillip Street,35th Floor,Sydney, New South Wales, 2000,Australia"
},
{
"name": "Sydney",
"Latitude": "-33.86488",
"Longitude": "151.21192",
"OfficeAddress": "88 Phillip Street,35th Floor,Sydney, New South Wales, 2000,Australia"
}
]
}
I needed output something as how this can be done? I am trying using json splitter but that works only on one column. This is a sample of one Region and oFiice. There are multiple regions having multiple office.
| REGION | OFFICE | LOCATION_NAME | LOCATION_OFFICEADDRESS | LOCATION_LONGITUDE | LOCATION_LATITUDE |
| Asia Pacific | Australia | Brisbane | Suite 4, L20 10 Eagle Street,Brisbane, Queensland, 4000,Australia | 153.0286812 | -27.4690555 |
| Asia Pacific | Australia | Canberra | Unit 8, Level 2, 11 National Circuit,Barton, ACT, 2600,Australia | 149.1304273 | -35.3084798 |
| Asia Pacific | Australia | Melbourne | Level 31, South Tower,80 Collins Street,Melbourne, Victoria 3000,Australia | 144.97097 | -37.81409 |
| Asia Pacific | Australia | Perth | Suite 4.02, Level 4,1 William St,Perth, Western Australia, 6000,Australia | 115.8533297 | -31.9556291 |
