CLEANING & PARSING MESSY DATA | I CAN ALTERYX THAT

Cleaning and parsing data are both individually massive topics when we talk about Alteryx’s capabilities. This video post will cover a couple of key areas.

  • Parsing on a delimiter with at Text to Columns tool.
  • Parsing dates manually using a Formula tool instead of a DateTime tool.
  • Remove superfluous quotation marks with a Multi-Field Formula instead of the more common Cleanse tool.

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 John Emery or I create some 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 our 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.