DOWNLOAD DATA & PARSE JSON | WEEKLY CHALLENGE #7 | I CAN ALTERYX THAT
In this challenge, you’ve been given a URL that returns a set of data in the JSON format. Your goal is to download that data, parse it, and format the data into a more user-friendly structure.
In this video, you will learn:
- How to download data from a URL using the Download tool.
- How to parse JSON data using the JSON Parse tool.
- How to dynamically rename fields using the Dynamic Rename tool.
- How to use filters, formulas, and pivots to restructure a dataset into a desired format.
Watch our YouTube video below to learn how to solve this weekly challenge.
What is "I CAN ALTERYX THAT"?
I CAN ALTERYX THAT is an ad hoc video series on YouTube created for Tessellation’s Data Coach product. Whenever Alex or I create something in Alteryx Designer that we think would be helpful for a broader audience, we record and share our development.
We don’t have a scheduled cadence, but follow our Data Coach YouTube channel or our I CAN ALTERYX THAT playlist to be notified when we have more content.