I Can Alteryx That - Download Data and Parse JSON

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.

Like what you are reading?

Get articles sent to you when they are posted.
Comments are closed.