Data, Alteryx and coffee

Data, Alteryx and coffee

What do data and coffee have in common? Quite a lot when you think about it! For example they both:  Are not consumable in their raw state Will require some altering  Can be highly addictive In our first week at The Data School Down Under we began using and learning...
Splitting to columns with Regex_replace in Alteryx

Splitting to columns with Regex_replace in Alteryx

The text to columns tool in Alteryx can sometimes be a little clunky. It’s a quick fix when you need each element of ‘Element1/Element2/Element3’ to be in it’s own column, but what if the string was ‘Element1/    Element2_     Element3    ’? This requires multiple...