Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jlahners
Contributor II
Contributor II

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!

0 Replies