Creating string calculations
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.
Getting ready
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.
How to do it…
Let us create a new sheet by pressing Ctrl + M and rename it String Calculation.
We will then drag the Customer Name field from the Dimensions...