community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #7: Download Data and Parse JSON

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
007.png
Asteroid
Spoiler
Challenge#7.png
Highlighted
Alteryx Partner

Solution attached.

 

 

Spoiler

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

 

The first option produces this (single string field):

option 2.png

 

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

 

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.

 

Alteryx Partner

Nice challenge. 

 

Solution attached. 

Asteroid

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.

Alteryx
Alteryx

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
image.png

My version.

Asteroid
Spoiler
7. Download Data and Parse JSON.PNG
Alteryx
Alteryx
Spoiler
I finally figured out how to use cross tab and transpose..

 

 

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