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

LiuZhang
9 - Comet

 

Spoiler
7.png

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

 

PatForData
8 - Asteroid
Spoiler
PatForData_0-1634904768813.png

 

Thomas_B
Alteryx
Alteryx
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?