Parse Eurostat JSON-stat data

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!

get_eurostat_data.yxmd

Download

Accepted answers

Thableaus

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,

get_eurostat_data.yxmd

All comments

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

irt_lt_mcby_q.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703