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
Magnetar
Magnetar

My solution. 

Spoiler
Was able to solve using most of my usual suspects (Cross-Tab, Text to Columns), but managed to get away from using multiple filter or sample tools by switching to the Select Records tool, which I have never used before... seems to me a good solution as long as the data structure doesn't change. But probably not a great solution if additional columns were ever added to the source data. Would need to think more dynamically in that case, perhaps using Multi-Row Formulas or parsing Formulas + Tiles?

WeeklyChallenge7.JPG
Highlighted
Alteryx Certified Partner

Challenge 7 done!

 

Spoiler
challenge7.jpg
Highlighted
Magnetar
Magnetar
 
Highlighted
Asteroid

I haven't worked with JSON before so after help research and trial and error...here is my solution

Spoiler
Week7SolutionPicture.png
Highlighted
Alteryx Certified Partner

Great exercise for dealing with JSON format data. Coincidentally I just created this exact workflow during a training session I was running today.

I connected to Quandl to collect Crude Oil Prices

Highlighted
Alteryx Certified Partner

I'm getting the hang of JSON now :)

 

Spoiler
Weekly Challenge 7.png
Highlighted
Meteoroid
My second challenge.
Spoiler
Screenshot - 2017-05-30 , 12_45_57.png
Highlighted
Meteoroid

My solution - @NicoleJohnson's idea with a generic OR.

 

Spoiler
Screen Shot 2017-06-09 at 12.34.47 PM.png
Highlighted
Alteryx Certified Partner

Solution attached.  On the JSON parse, I used the option to 'Output values into data type specific fields' which led to a slightly different solution.  The Dynamic Rename used in provided solution looks useful.  I'll keep that in mind.


Ken

Highlighted
Alteryx Certified Partner

Had to do a few of these API Calls before, so this was a quick one.

Spoiler
WC6.png