Splitting Fields in Alteryx

As part of the data prep process, you may need to read in a text file, or split a variable into a few new ones. This is because the text file/ variable contains a string of information, separated by a delimiter (e.g. – , / _ ). This will read this as one value and to...

Splitting Fields in Tableau

Sometimes a few of your data fields will be in one column, stored as text with a delimiter (e.g. – , / _ ). Tableau will read this as one value and to have it as more than that you need to tell Tableau to split the field. There are three ways you can do this in...

DS11: the first week

With week 2 well underway, I thought it would be a good opportunity to reflect back on our first week as dataschoolers! Whilst I was excited to start DS11, I was also quite nervous! Thankfully that dissipated throughout the week, as everyone was so friendly and made a...

Alteryx Essentials: Multi-Row Formula

The afternoon of Day 2 started with a sort of pre-introduction to Alteryx before the main introduction course of day 3 and 4 of DS11: week 1. As Tableau is part of the Data School interview process we were all fairly familiar with it, but this was the first chance...