Help with parsing JSON

jlahners — Wed, 24 Oct 2018 15:35:19 GMT

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_ID	barcode
AAA	AAA111BBB
BBB	BBB222CCC

Any help would be appreciated!

topic Help with parsing JSON in App Development