Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
jlahners
New Contributor

Help with parsing JSON

Hi all -

Need some help with a JSON parsing challenge.  I have data from our database that looks like the following:

[SOMEDATA]:

LOAD * INLINE

[

ROW_ID;FullBarcode

AAA;{ "type":"type123","barcode":"AAA111BBB"}

BBB;{ "type":"type900","barcode":"BBB222CCC"}

](delimiter is ';');

I've used:

LOAD type, barcode FROM_FIELD (SOMEDATA,FullBarcode) (json);

and it pulls the individual fields, however I lose the association with the ROW_ID.

I need to create a new data row similar to:

ROW_IDbarcode
AAAAAA111BBB
BBBBBB222CCC

Any help would be appreciated!

Tags (1)