PARSING VIDEO GAME DATA | WEEKLY CHALLENGE #207 | I CAN ALTERYX THAT

In this challenge, we’ve been provided with a list of video game data. Unfortunately, the data is all in one column, so we must use Text To Columns and Reg Ex tools to split the data apart.

In this video, you will learn:

  • How to write complex regular expressions to parse data that has many components.
  • How to tokenize a data set using both Reg Ex and Text To Columns tools.
  • Use Cross Tab and Dynamic Rename tools to pivot and rename columns dynamically.

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.