Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

ferg_smith
8 - Asteroid
Spoiler
ferg_smith_0-1673430235559.png

 

karlhansen
9 - Comet
Spoiler
solution_7.jpg
kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_7_KU.png
BS_THE_ANALYST
15 - Aurora
15 - Aurora

Nice.

Spoiler
BS_THE_ANALYST_1-1673868152860.png
All the best,
BS

LinkedIN

Bulien
BS_THE_ANALYST
15 - Aurora
15 - Aurora

Alternate approach, much more dynamic using the JSON Parse tool 😀. Inspired from @MarqueeCrew's solution, again 👏.

Spoiler
BS_THE_ANALYST_0-1673872180424.png
All the best,
BS

LinkedIN

Bulien
François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1673978299410.png

 

JFarrierMa001
7 - Meteor
Spoiler
JFarrierMa001_0-1675431665257.png

 

lucascs
8 - Asteroid

solved

patrickprentice
8 - Asteroid

I feel like this is something I could do much quicker and easier in R.  Took me way too long to figure this one out.  Solution:

mgaronson
11 - Bolide
Spoiler
mgaronson_1-1676217200882.png

 

Hey, there's a json parse tool in Alteryx! Method 1 - Regex. Method 2 json parse tool. Sigh.