PROPER() Function: The Game Changer. New in Tableau 2022.4
In the earlier version of Tableau, no string function could do a Title or Proper case. People used to combine the logic of different functions like RIGHT(), LEFT(), UPPER(), LOWER(), etc.
Tableau has introduced a Title Case Function called PROPER() which can be used to convert any String to a Title case.
I will show the example with PROPER() and a mix of Logic of String Functions
Let’s say I want to do a Title Case for the below string list.
After importing this to Tableau, It would look like this as shown below.
I would create a Calculation to make this a Title case. This was the attempt followed by people before PROPER() was introduced. There can be more solutions like this.
Now, you have a function PROPER() that can do your job easily. Here is the Calculation with PROPER()
Hope you found this article useful. Thanks for reading.
Vignesh Suresh
