Parse Eurostat JSON-stat data

[jasatt]

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!

[Thableaus]

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,

[jasatt]

Hello.

Thanks for your reply.

I am interested in a methdology to parse the data. I can use the API to filter the data for each country I need, but i would rather if I get all the data together. The output I need is in the attached.

Kind regards,

Jason

[jasatt]

Hello -

Is there anyone who can help me in parsing the JSON-stat data?

Thanks!

[Thableaus · Accepted solution]

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,

[jasatt]

Thanks and well done! This works great.