Discussion board where members can get started with Qlik Sense.
I have problem related to loading a field and using JSON "->>" syntax. Example:
[json_data]->>'key1' as field_1,
[json_data]->>key2' as field_2
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.
I found solution for this.
It was simply that I had wrong format.
When using [json_data]->>'key1' as field_1 syntax one needs to make sure you use  in all LOAD statement data fields and load those.
I had some fields without  and that caused the error.