Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #7: Download Data and Parse JSON

Highlighted
Alteryx Certified Partner

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

Highlighted
Atom

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

Highlighted

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

Highlighted
Sr. Instructional Designer
Sr. Instructional Designer

@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!

Highlighted
Alteryx Certified Partner

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

 

Spoiler
Screen Shot 2017-08-27 at 11.25.54.png
Highlighted
Alteryx Certified Partner

Solution attached

Spoiler
Screen Shot 2017-08-27 at 20.47.37.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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
Crosstab Real.PNG

 

 

Highlighted
Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner

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.

Highlighted
Asteroid

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