Alteryx: splitting hairs (strings)

by Andrew Lehm

Tom and I had our first experience with Alteryx today and our afternoon task was to tidy up some data gleaned from seafood recipes online.

You can see how Tom tackled the task of converting the time data from string to numerical here.

My task was to split a string of instructions into multiple rows of data. Simple enough, right?




The first thing to do was to split the Directions data into multiple rows, I did this by using the Text to columns tool and selecting “.” as the delimiter.


After transposing the data, I very cleverly used 7 separate filters to filter out the rows containing the numbers that had been split out of the original data.





A simple merge with Tom’s data later and the workbook was ready for exporting. You can see how I turned it into a stacked bar chart here.



© 2022 The Information Lab Ltd. All rights reserved.