ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

bblock
Meteoro

I didn't realize that we had to dynamically create the column headers.  I manually did it in my solution.  It is fairly simple compared to the posted solution.

jzondervan
Meteoro

Had some experience with Alteryx and JSON parsing already, so not very difficult to do!

Samanthaj_hughes
ACE Emeritus
ACE Emeritus

Solution Attached.

#Alteryxrocks
Brian6
Asteroide
 
yavdaanalytics
Asteroide

Eventually figured out the solution. 

Spoiler
image.png
yavdaanalytics
Asteroide

Improvised my solution with some thought process..

Spoiler
image.png
JoBen
Bólido

Cheers!

vkarthik21
Asteroide

Got it to work. Had to stumble a bit to get that ranking properly otherwise it was good challenge. As someone said quite early in the post, this opens up lot of possibilities on what can be done using JSON data. Here is my attached solution.

 

Also need to check out other easier ways to do this :) 

DavidP
17 - Castor
17 - Castor

My solution

Walsh67
Asteroide

My solution...