Did you know about the new PROPER string function in 2022.4?

Tableau 2022.4 has introduced a new string function called PROPER which allows us to convert our text string to proper title casing by capitalizing the first letter of each word while lower casing all other letters.

In this view I have Customer Name, First Name and Last Name but we observe that First name is upper cased whiles last name is lower cased.

Using the proper function, we can write an adhoc formular in the row shelf to change the first name or last name to a proper title case.

In the same vein, calculated fields can be used to concatenate First and Last name while wrapping them in the PROPER function and renaming as full name.

Nice, easy and handy and I hope this update was useful. Thanks for reading.

Author:
Michael Apau
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab