Hello -
I would like to parse Eurostat json-stat data; are there any tools within Alteryx that can help me parse the result into a table?
Workflow with the data I want to get is attached.
Thanks!
Solved! Go to Solution.
Hi @jasatt
There's a lot of data in your JSON string.
What's your desired output? What is the valuable information for you? (Which columns matter the most)
Cheers,
Hello -
Is there anyone who can help me in parsing the JSON-stat data?
Thanks!
Hi @jasatt
Here's an idea of what to do. Workflow attached.
First I had some trouble to understand the JSON values, but the thing is that you need to create a table with every Country and respective Time_label.
For that, you need to use append fields. Then, RecordID for that combination (Country and Time) will link the number associated with Status and Value.
The other fields and dimensions I did not dive into but it should be easy. It's up to you how to handle them.
Cheers,
Thanks and well done! This works great.