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...
A quick guide to Web Scraping

A quick guide to Web Scraping

The term web scraping may not sound attractive, but last week we got the opportunity to really delve in to it, using a Zomato API to download data off their website. Their API allows you to access detailed information on each of the restaurants which you can massage...