1 Reply Latest reply: May 7, 2018 1:57 AM by Jani Henriksson RSS

    Problem in loading data fields and reading content from a field containing multiple data points in JSON format

    Jani Henriksson

      Hi there,

       

      I have problem related to loading a field and using JSON "->>" syntax. Example:

      LOAD [id],

                [json_data];

      SELECT "id",

                [json_data]->>'key1' as field_1,

                [json_data]->>key2' as field_2

      FROM TABLE;

       

      My question is that as I have several data fields within a single field  json_data, how can I add those to the available list in Qlik Sense.

       

      In order to do this I would need to use LOAD statement. But because I need to first read the JSON text with SELECT, I cannot normally do this.

       

      Yes, naturally there are some workarounds to create a separate table as part of the ETL process, but it would be nicer just to do this json reading part within Qlik.