Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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