top of page
Ed Orlando
Data Scientist | White Lodging
Alteryx Weekly Challenge #2
Preparing Delimited Data
https://community.alteryx.com/t5/forums/recentpostspage/user-id/19037
Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control characters within them. Having more than one type of delimiter can be hard for ETL programs to interpret.
In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.
Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output
Data Set #1
Workflow with Detail
Final Data Set Solution
bottom of page