top of page

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