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!
