In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #7: Download Data and Parse JSON

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1633715970640.png

 

radu_gabriel
6 - Meteoroid

My solution

AlexvanOs
8 - Asteroid

My solution

Spoiler
Since the JSON provided lovely row-column values, I decided to use those to parse my data in rows and columns.
I did need a few extra steps to make my flow flexible for future additions to the outbound values, but I think it turned out nicely.
Challenge 7 solution.png



I was however a bit disappointed that while the challenge states outbound statistics, the solution provided in the starting post shows inbound statistics.

jonathanwillis
8 - Asteroid

Here's my submission. Had to grab a solution to confirm because I think the numbers may have changed a bit

leozhang2work
10 - Fireball

 

Spoiler
7.png

JSON always give a good chance to practice with create Record ID

 

PatForData
8 - Asteroid
Spoiler
PatForData_0-1634904768813.png

 

Thomas_W
8 - Asteroid
Spoiler
Thomas_B_0-1635276019331.png

 

dYoast
11 - Bolide

This was interesting.  My results are different, likely to updated data from the download.

Spoiler
dYoast_0-1637004217660.png

 

bktaylor
8 - Asteroid

Here's my solution.

 

Spoiler
bktaylor_0-1637016170434.png

 

jestinejoseph
8 - Asteroid

When using Download tool and trying to run the workflow it says "Download (95) Error transferring data: Couldn't connect to server". Tried multiple times still same response. Is the link to the dataset expired or am I missing something in configuration?