Hi,
I’m struggling with reading JSON as a flat table, which I could use in GIS.
I have the following JSON:
I enabled option “Flatten Nested JSON Values into Attributes” but that produced one row with many columns. In some other post someone proposed a query jsonr"collection"]
What options should I use to produce a flat table with JSON attributes as column names?
A JSONFragmenter with Flatten Query Result into Attributes set to Yes
You will need to expose the attributes, this can be done in the JSONFragmenter itself or in an AttributeExposer (easier as you can load from the cache)
Sorry for maybe stupid question: what is your input to JSONFragmenter?
I used JSON Reader and I don’t have an option in JSON Attribute = ‘json’:
Are you using another reader?
If you use a textfile reader and read whole file at once, you will have a text_line_data attribute that you can use as the json attribute