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.

Subscribe to Our 'Data Cap' Newsletter!

Want a monthly insights from the Tessellation Team with tips, tricks, and secrets to improve your analytics?

Sign up below and we'll deliver articles, events, and how to's straight to your inbox.
Comments are closed.