Challenge #7: Download Data and Parse JSON

[Assaf_m]

Solution Attached

[Original_Yodies]

This is a good one. I'm sure there are more elegant solutions though, i cant wait to browse through them.

Spoiler

[timrains]

Nice challenge. All done. 

Spoiler

[varunvarma87]

Challenge 7 completed 

Spoiler

[kmbutterfield]

First ever Advanced Challenge!

[BSilverblatt]

Thanks for the challenge! This is my solution.

[Dazzerman]

A very interesting exercise!  I hadn't worked with data in JSON format in Alteryx before so enjoyed shaping the data into the required output.

My solution :

Spoiler

Note that I have included an Alteryx database in my workflow.  This is because the Download Tool was giving me intermittent errors.  I wondered if there was a problem with the website, but was able to access the data via a normal IE browser.  Either way, the data is saved for prosperity...

[adams_ca]

Fun one!

My solution attached.

Spoiler

[Parul_Kapoor]

Pls find attached sol.

[jenniferk]

Spoiler