Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2024 09:05 AM
Even though the data in the column seems like a JSON formatted the data type is string, so using your code and suggestions from databricks below is the code i have tried below code:
SELECT *,
get_json_object(XMLData, '$.Response.IdNumber') AS id_number,
get_json_object(XMLData, '$.Status.Code:') AS Code
FROM default.sampledata;
I get NULL values in the output, am i missing something in here?
