+3Hi,
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 json["collection"][*], but that also didn’t work.
What options should I use to produce a flat table with JSON attributes as column names?
Best answer by ebygomm
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)
+45A 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)
+3Sorry 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?
+45If 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
