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

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
11 - Bolide

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
9 - Comet

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