community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

nakamott
8 - Asteroid
‎06-18-2019 05:01 PM

used select records instead of regex

challenge_7_TMN.yxmd
Reply
0 Likes
papalow
8 - Asteroid
‎06-18-2019 10:44 PM

First time working with a json file.  It was a good challenge.

challenge_7_Solution_papalow.yxmd
Reply
0 Likes
Hannah_Lissaman
11 - Bolide
‎06-20-2019 01:39 AM

All done!

challenge_7_Solution.yxmd
Reply
0 Likes
Jonathan-Sherman
15 - Aurora
15 - Aurora
‎06-20-2019 10:06 AM

Challenge 7 is done!

 

Spoiler
challenge 7 JMS solution.PNG
challenge_7_JMS_solution.yxmd
Reply
0 Likes
Reesetrain2
9 - Comet
9 - Comet
‎06-20-2019 06:24 PM

All,

 

My submission is attached!

-I used a combination of CrossTab and Text-to-columns for my approach.

Cheers!

Matt

Spoiler
Capture.PNG
challenge_7_Reesetrain_Submission.yxzp
Reply
0 Likes
Greg_Murray
12 - Quasar
‎06-20-2019 07:44 PM
Spoiler
Capture.PNG

Solution Attached

challenge_7_solution GM.yxmd
Reply
0 Likes
DanielMS
Alteryx Alumni (Retired)
‎06-26-2019 03:16 AM
Spoiler
Spoiler.PNG
Dan_Salway_challenge_7.yxmd
Reply
0 Likes
bnelly1987
8 - Asteroid
‎06-26-2019 03:08 PM

First time using an API. Great example!

Spoiler
Solution-Challenge 007.PNG
challenge_7_start_file.yxmd
Reply
0 Likes
lavanyadurai
7 - Meteor
‎06-27-2019 04:11 AM

Attached is my solution

Spoiler
Challenge7.PNG

 

challenge_7_output.yxmd
Reply
0 Likes
lavanyadurai
7 - Meteor
‎06-27-2019 04:34 AM
Spoiler
Challenge7.PNG
challenge_7_output.yxmd
Reply
0 Likes