There are times when we are required to do some manipulations on fields that are stored as strings. Typical calculations that we may do on strings are as follows:
Concatenating separate strings into a single string or separate a string into smaller substrings
Changing the letter case (upper case to lower case and vice versa)
Extracting parts of the string to find certain substrings or find the position of a particular character or trim the string from a particular point
In the following recipe, let's do some string manipulations to create new calculated fields.
For the following recipe, we will use the Customer Name field from the Orders sheet from Sample - Superstore.xlsx
data and we will continue working in the same workbook, My first Tableau Workbook
.
Let us get started by creating a fresh new sheet.