I’m a little Data Schooler in a deep Tableau sea | Part 1 : Pre-Conference Build-up

This is part of a blog series I am about to write on my journey leading up to and post Tableau conference. Part 1 : Pre-Conference Build-up Some of you may ask what is a 'Data Schooler'. Well we are students at The Information Lab and are part of The Data School. We go through intensive …

Using Multi-field to remove quotes in Alteryx

I stumbled across this handy formula. Let’s say we have data that looks like this First thing I need to do is ‘Text to Columns’ to split the subject and level apart Split to 2 columns by a ‘comma’ ,. Now the data looks like below. We can remove the first field, but we need …

Multiple outputs from Alteryx

Whilst I am prepping for my Alteryx exam, anything new that I come across will become a blog. This way I remember what I have done and hopefully I can help the readers understand how to do the specific technique and process. This time it is producing multiple outputs from one file. I am going …

Using REGEX to replace in Alteryx

My thoughts about REGEX today went a little bit like this "REGEX could change my life" "REGEX I HATE YOU" "OHH I get it now" If you don't get these thoughts whilst learning REGEX in Alteryx then you are a genius! So now- I am going to explain how to use the 'Replace' option in …

Using dynamic input to insert multiple excel tabs at once in Alteryx

Whilst I was doing some personal work this morning I came across a problem. I had an excel file which had 12 tabs and I wanted to union all those tabs together. With a quick google I was able to find my answer but I thought I would blog about my process. So lets start …

Synchronising Dual Axis Problem – Different Data Types

Ever had problems synchronising your dual axis? Well here could be the answer. Let's say we have a chart that looks like this The scale of these measures are not the same, but the way this chart is currently set up is very misleading. We want to synchronise the axis to enable a direct comparison. …

Measure Names as last column header in a table

I know the idea of Tableau is not to just recreate tables. But sometimes there is a need for a table. In this post I am going to show you how to use the end column and have a column title. Let's say you want these columns as your table. But as you can see …

Alteryx Dynamic Rename – vlookup option

I have header names that are abbreviations but in another table I have the abbreviations and the full word. I wanted to replace the abbreviations with the full words. Lets say our data looks like this But we have a reference table that looks like this We can see that the abbreviated headers are in …

Using Dynamic Rename to Update Column Names in Alteryx

The dynamic rename tool is a great tool if your spreadsheets comes in with lines at the top which have nothing to do with your actual data. Let’s say your data looks like this. My column name are row 1 of the data set. This is where we can use the dynamic rename tool change …

Removing Nulls from Multiple Columns in Alteryx

Lets say we have numerous columns that have null values in them We can use the Multi-Field Formula Tool Change to text fields, as those are the ones with nulls in. Select all the fields that have nulls Make sure you untick the copy output fields, unless you want new columns. Then to remove the …