Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #7: Download Data and Parse JSON

Highlighted
Alteryx Partner
 
Highlighted
Alteryx Partner

Here's my solution to challenge 7.

Spoiler
CH07_Solution.PNG

 

Highlighted
Asteroid

Here's my solution!

Spoiler
Capture.PNG
Meteor

Number 7

Highlighted
Meteor

Here's my solution for this one. Thanks,


Will

Highlighted
Alteryx Partner
 
Highlighted
Asteroid
good exercise - Thank you - Here is my proposed solution.
Highlighted
Fireball

#7 done - great to see all the alternative approaches posted on this one.

Highlighted
Alteryx
Alteryx

Challenge completed by separating out the data into 2 streams, one with the headers and the other with the data values. Cross tab both streams and bring back together with a Union

 

Used text to columns to get Record IDs as regex isn't as strong!

Highlighted
Alteryx Certified Partner

Here is my solution !