Problem loading JSON Eurostat data

mkelemen — Thu, 23 Dec 2021 13:40:23 GMT

Hi community,

I am trying to load JSON data from Eurostat. I have problem because the values are not stored in an array but in an object.

"value" : { "0": 1.3587, "18": 1.5849 }

The REST connector uses the "0" and "18" as fields but what I need is to have two fields - index and value.

What REST connector gives me:

0	18
1.3587	1.5849

What I need:

Index	Value
0	1.3587
18	1.5849

I tried to load a different dataset which stores values in an array [] and this worked as expected.

Is there a way to force REST connector to load values this way?

Thanks,

Matus

Re: Problem loading JSON Eurostat data

Gysbert_Wassenaar — Sat, 01 Dec 2018 11:39:20 GMT

You should be able to use the CrossTable function to transform the data.

And the rest connector is actually correct in loading the data the way it does. The json you posted does not have an "index" field. There's no way that I know of to make the rest connector ignore the json specification and apply an arbitrary other definition for parsing the json data.

topic Problem loading JSON Eurostat data in Connectivity & Data Prep

Problem loading JSON Eurostat data

Re: Problem loading JSON Eurostat data