5
Data Parsing
Data parsing is vital when preparing data for analysis. Converting data from one format (or no format) and being able to identify and extract data pieces from a field is a crucial procedure for making semi-unusable data useful.
In this chapter, we’ll present recipes to parse/extract data that may look unusable or too complicated to interpret at first. These are the recipes we will cover:
- Preparing a free text field for analysis/patterns findings
- Identifying and classifying free text
- Extracting the last part of a delimited field
- Using ReGex or not
Technical requirements
For this chapter, we don’t need any extra preparation besides having Alteryx Designer installed on our computers.
Preparing, identifying, and classifying free ...
Get Alteryx Designer Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
