We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #7: Download Data and Parse JSON

keynguyen
8 - Asteroid
Spoiler
Spoilerchallenge 7 sol.png

OzlemSigbeku
8 - Asteroid
Spoiler
OzlemSigbeku_0-1667233531072.png

 

LukeD
6 - Meteoroid

Please find attached my solution to challenge #7

NicolasSz
10 - Fireball

Please see my answer attached.

Slightly different output than the expected result but I think its because the API returns different results now. 

I find my solution more flexible than the provided solution which is hardcoding the position of the columns.

 

Thanks

Flo_P
8 - Asteroid

Not optimal but got there anyway

benjimoser
8 - Asteroid

Here is my solution. 
Note: 
- The output in the start file is incorrect (missing one row).

- I build the JSON parsing in a dynamic way (it extracts all columns and no adjustments are needed in case the amount of columns will change in the source data)

@Flo_P Have a look ;) 

Supergiant
8 - Asteroid

Looks like Json Parse tool makes thing more complicated so I approach it differently

 

Spoiler
Supergiant_0-1668203489094.png

 

Dantastic
8 - Asteroid

solved

pmyers
Alteryx
Alteryx
Spoiler
pmyers_0-1668896092802.png

 

Linas
8 - Asteroid
Spoiler
Linas_0-1669294184339.png