Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

extracting coordinates from json

payload" :
 {
        "asset" : "356363051312744",
              "loc" : ,
    "fields" : {
      "GPS_DIR" : {
        "b64_value" : "AABKLg=="
}
}
}
i have json in this format i would like to extract 'loc' from it, when i give the xpath query as ("../loc") it extracts only the first part i.e. '80.25641' i tried with each and every data type available like string, big decimal, etc but the second part is not showing up.

plz help some one... 
Labels (3)
1 Reply
_AnonymousUser
Specialist III
Specialist III

If you want to extract that data once only, you can paste the JSON into json-csv.com then open the CSV file in Excel to extract the data.