Challenge #7: Download Data and Parse JSON

[nick_ceneviva]

The very first record seems to be off by a little bit but everything else matches.  Solution is attached.

[jingmu]

It seems like the original json link is no longer working. Any chance we have an updated link?

[dheerajpoojari]

Updated link, please. Quandl seems to have removed this data set.

[ChristineB]

@jingmu and @dheerajpoojari: Thank you for bringing this to our attention!  Unfortunately, it seems that the original dataset that was used to create this exercise has been removed from Quandl's site.  However, I adjusted the Challenge to call a new dataset on outbound tourism from the US.  The Start File contains a link to that dataset,  and the Solution has been updated as well. 

Thanks again, and happy Alteryx-ing!

[jamielaird]

Hi all!  Another great challenge.  Here's my solution:

Spoiler

[Natasha]

Solution attached

Spoiler

[BenMoss]

This was an interesting challenge especially in the aspect of ensuring the headers are correct after performing the cross-tab which I got round with by using a union and dynamic rename.

Spoiler

[patrick_digan]

Spoiler

[MaxGiegerich]

Great example. Downloading JSON data through public APIs is such an important use case for Alteryx as it opens up a world of data for free! I struggled a bit with the dynamic rename formatting the unicode characters as '___' but used a blog post (https://mixpixviz.blogspot.co.uk/2016/06/controlling-format-of-cross-tab-header.html) to get to the solution.

[Amarendra]

Solution attached. Recently worked on a similar project and was fairly easy to finish this.