Challenge #7: Download Data and Parse JSON

[NicoleJohnson]

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?

[Laurap1228]

Challenge 7 done!

Spoiler

[DE0413]

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

Spoiler

[Phil_L57]

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

[LordNeilLord]

I'm getting the hang of JSON now :)

Spoiler

[Pavel_G]

My second challenge.

Spoiler

[iiyoob]

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

Spoiler

[KOBoyle]

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

[PhilipMannering]

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

Spoiler