Alteryx quick tip: Change sentence case

by Naledi Hollbruegge

I am currently working on election data from the 2016 London Mayoral election. In this dataset they annoyingly capitalised a proportion of the ward names. In order to alter the capitalisation in a column you can use the Data Cleansing tool. Just drag this to the relevant place in the workflow, select the fields that you would like to change and go all the way down to the last option “Modify Case”. Here you can now select if you would like to capitalise everything, nothing or just the first letter of each word. In my case I set it to Title Case, so that just the first letter of each Ward was capitalised.

This function was also helpful when I was merging 15 sheets from the same workbook. While they looked like they were set up exactly the same way, it turned out that the headers had typos and were sometimes capitalised and sometimes not, which then became an issue when trying to union these based on column headers. Setting them all to lower case sorted out some of these issues.

Capitalised

Change case

Avatar

Naledi Hollbruegge

Custom Geocoding in Tableau: Mapping London Tube Stops

3 mins read

Thu 25 Aug 2016

Tableau Tip Tuesday: Hiding the null indicator

2 mins read

Tue 23 Aug 2016

Alteryx Quick Tip: Find your tool number

2 mins read

Mon 22 Aug 2016

Making an app with the List Box tool in Alteryx

3 mins read

Mon 15 Aug 2016