Five time-saving Alteryx tips, part 3: Reading data from .csv files

by Anna Prosvetova

Data sets come in different shapes and forms, and .csv files are one of the most frequent formats. CSV stands for ‘comma-separated values’ and means that the fields in the data set are separated (or delimited) by commas. However, other types of delimiters can be used in .csv files such as a tab, space, colon, or a pipe symbol (|), as in the example below.

By default, Alteryx sets a delimiter as a comma when you input a .csv file using the Input tool. However, if the dataset uses a different delimiter, the data will be brought into Alteryx as one column or you might get an error message. Before I figured out how to change the delimeter directly in the Input tool, I used to use the Text to Columns tool to split the data in separate fields. This post will show you how to avoid this extra step.

Let’s carry on with the data in the example above. We know that the data is delimited by a pipe symbol, so we need to set it as the delimiter in the Options window of the Input tool’s configuration pane. After running the workflow you should get the dataset in the correct format as in the image below.

Let me know if you have any questions and make sure to check out the other posts in my ‘Five time-saving Alteryx tips’ series:

Avatar

Anna Prosvetova

Five time-saving Alteryx tips, part 5: Making use of field metadata with the Field Info tool

3 mins read

Wed 29 Jan 2020

Five time-saving Alteryx tips, part 4: Filling the date gaps with the TS Filler tool

2 mins read

Tue 28 Jan 2020

Five time-saving Alteryx tips, part 2: Sort your data in fewer clicks

2 mins read

Sun 26 Jan 2020

Five time-saving Alteryx tips, part 1: Finding your way around your workflow

3 mins read

Sun 19 Jan 2020