Hi @mda , I think what you need is to fragment the JSON array named "attributes" and flatten every fragmented object. You can use either the regular JSON reader or the JSONFragmenter to do that.
JSONReader: In the Add Reader dialog, after specifying Format and selecting the file as its Dataset, open the reader parameters dialog and set the parameters with JSON Query mode, like this. Here, Feature Type name can be any.
JSONFragmenter: Set the parameters like this.
Other than entering a JSON Query into the Query column field directly, you can also use the Select Query dialog, in either the JSON Reader or the JSONFragmenter.
Hi @mda , I think what you need is to fragment the JSON array named "attributes" and flatten every fragmented object. You can use either the regular JSON reader or the JSONFragmenter to do that.
JSONReader: In the Add Reader dialog, after specifying Format and selecting the file as its Dataset, open the reader parameters dialog and set the parameters with JSON Query mode, like this. Here, Feature Type name can be any.
JSONFragmenter: Set the parameters like this.
Other than entering a JSON Query into the Query column field directly, you can also use the Select Query dialog, in either the JSON Reader or the JSONFragmenter.
Thank you ver much! That helps. I always mislocating the
.
@Takashi Iijima Further to my previous question, I get now two attributes "Naam" en "Value". The contents of the "Naam"attribute are actually attributes names and the contents of the "Value"attrbute are the values. So what I need is to transpose the "Naam" attribute to columns and fill those columns with the content of the "Value"attribute (see attachments). I have tried attributepivoter and also attribute Transposer custom transformer. Unfortunatley, I keep getting nothing useful or empy output. Could you please help me with this!
This is the wanted results form
Yes, I needed to use AttributeExposer after the AttributeTranspose :)