Parsing a Simple Field with Single Level JSON data using From_field()

This is a simple example that works with flat json, meaning non-nested json hierarchies. However, you can use a combination of other functions like JSONGET() and JSONSET() to extract needed data. More examples on this to follow.

Playlist:

Qlik Help: LOAD()

JSONGET()

[CotisoHanganu]

Very inspired and important clarification regarding the CustID field pre-existing in the json. Tx

[sabka_answer]

Very informative and useful. will use this field in my current project. we are dealing with json data and for that we had written python script to convert single column value into multi column.

[dineshnandan]

Wow, very informative, will try morrow.

[CotisoHanganu]

Tx for sharing !

Do have some questions, Mike:
1. Where and how did you defined the customer_id as a key field between the original table and the new table ?
2. It seems to me that in case the JSON field has various subfields in different rows, there will be separate resident tables for each subset of subfields, while there is no more key to the main table. Is it the right behaviour to be expected ?
3. It seems to me that in case one row has the JSON cell empty, there will be a "file not found error" => perhaps the error handling need some improvements ?
4. Should FROM_FIELD work in Qlikview, as well ?

Tx

[eduardochild]

Can i use the From_Field to parse XML files?

[pauljohansson]

@pauljohansson4809
16 seconds ago (edited)
from_field is very easy to use. In my case though, the performance was simply to poor. Do you have performance issues when unwraping using from_field? - look into doing on the DB side.