Challenge #7: Download Data and Parse JSON

[cAral]

neat

[AlejandroMS]

Good excercise, had to research how to parse a webpage and a Json file, which was really helpful

From the solution I see I varied on how to filter not using the RegEx.

[LukasJennings]

Spoiler

[hoadinh]

My solution:

[Tomasch]

done

[DanTh]

Spoiler

Slightly messy solution, so interested in being more efficient, but pleased with how I got to the outcome. A good reminder of Dynamic Rename!

4/5

[Elias_Nordlinder]

Okay, this one got really messy, haha.

Not used to work with JSON, first time, and did a bit too much parsing, but managed the challenge at least 🙂

Spoiler

[dhavaldoshi]

How to do it as a beginner?

There couldn't be a better way to show off Alteryx's download skills to show web scrapping abilities for heavy data download from structured sources

• Plug in the Download Tool coupled with a JSON parse
• Play a bit with Cross Tab and voila!

Spoiler

[j_christian]

Solution attached:

[JoaoLeiteV]

This was a very nice challenge, I've never used the JSON Parse tool before.

Spoiler