Challenge #7: Download Data and Parse JSON

[David-Carnes]

I use the Download tool quite a bit.  It's great for pulling data from some of our cloud-based software providers or stitching together different services to create new and exciting apps,

It appears that the number of rows returned from Quandl has changed since this challenge was initially posted, probably due to a change in service terms or something.

Spoiler

[RotesDB]

Spoiler

[arno_bürgin]

Solution attached.

Spoiler

I took a detour because I wasn't attentive to the options in the "JSON Parse" tool:

The first option produces this (single string field):

The second option produces this (data type specific fields):

I chose the second option (data type specific fields) and it took me some steps to cross tab/transpose the values back into one field. Unnecessarily so, as I realised when I looked at the solution.

[robcarroll]

Nice challenge. 

Solution attached. 

[alexo]

The developer tools tab is really useful - I'd never used the download or json parse tool before and they worked exactly how I would've expected them to.

[KMcKean]

This one was tricky!  I feel like there's some room for improvement in how I use transpose and cross tab.  Got there in the end, though!

Spoiler

[piotrzawistowski]

My version.

[fmeo]

Spoiler

[KevinH1992]

Spoiler

I finally figured out how to use cross tab and transpose..

[garrettlem1017]

Cross tab and dynamic rename tools allowed for easy manipulation of data.