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.