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

Asteroid

Hi All,

 

Please find my Result below.

 

Spoiler
Used the Download Tool, Parsed the JSON, Filtered then separated the headers, Cross tabbed the rest of the Rows and joined them using a Dynamic Rename, Used a Select to drop the excess and sorted the output.

Thanks

Mat

Asteroid

Why isn't there a tool to turn JSON into a table in one step? hmmm

Spoiler
ZHSOL7.png
Alteryx Partner

My Solution

Spoiler
challenge_7_RODO_Solution.png
Meteor
Spoiler
image.png
Asteroid

My Solution: 

Alteryx Certified Partner

Allways good with some download tool stuff:

Spoiler
challenge_7_Done_img.png

Highlighted
Asteroid

I enjoyed this one!

Bolide

Reposting to add spoiler (to get challenge tracker to work correctly)

 

Spoiler
Workflow 7.JPG

 

Alteryx Partner

Nice challenge!

Asteroid

I enjoyed that one!