05-23-2024 02:14 AM
{
"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 sample of one Location and Region there are hundreds like them.
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 |
05-27-2024 10:43 AM
Can anyone help here?
05-27-2024 11:53 PM
This expression should help $Location.map(x => x.extend({"Office":$Office, "Region":$Region}))
Please note
05-30-2024 08:28 AM
@girishrawat You can achieve your usecase using json splitter snap. Following are the jsonsplitter snap settings.