I'm reading a number of json files each with their own set of records. I can see I need to expose many attributes but without adding hundreds of lines (the index goes to 142). Is there any easy way to go from screengrab below to web site structure at http://reg.bom.gov.au/products/IDT60801/IDT60801.94850.shtml:
Solved
Attribute Exposer many fields?
Best answer by hkingsbury
have a look at the attached. Makes use of the JSONFragmenter to both read the JSON and break it down
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+44- Influencer
- 3422 replies
When you say index do you mean you have fields which are like observations.data{142}.[attributename] ?
Because that number relates to the number of features in the list, not the number of attributes.
If you explode the observations.data list, you can then expose the attributes to get a similar sort of data structure to the web page. If you are using 2020 or above, you can use the feature cache to automatically populate the attributes to expose.
+63- Celebrity
- 1620 replies
- Best Answer
have a look at the attached. Makes use of the JSONFragmenter to both read the JSON and break it down
+23- Enthusiast
- 83 replies
have a look at the attached. Makes use of the JSONFragmenter to both read the JSON and break it down
Hi @hkingsbury,
I think this is a great answer to this problem.
Quick question, do your output attributes sort alphabetically even when Sort Attributes = 'None' in the SchemaSetter?
+23- Contributor
- 571 replies
You can save one JSON file to disk and use Import -> From Dataset in AttributeExposer
+63- Celebrity
- 1620 replies
Hi @hkingsbury,
I think this is a great answer to this problem.
Quick question, do your output attributes sort alphabetically even when Sort Attributes = 'None' in the SchemaSetter?
I faced this exact issue yesterday on a completely unrelated (to this) piece of work. Short answer is reorder fields in attribute manager doesn't change the actual order of the attributes. So the 'none' in the SchemaSetter is not really doing anything.
Here are some other articles on the matter:
https://community.safe.com/s/question/0D54Q000080hC3L/attribute-order-keeping