Tableau Title case

 Tableau converting text case 

• UPPER case function

• lower case function

• Proper case function

UPPER case function:

The upper case function converts all letters to uppercase (capital letters)

ex:

Function Name:

UPPER (Name)

Result:

Name: AJAY KUMAR

lower case function:

The lower case function converts all letters to lowercase.(small letters)

ex:

Function Name:

LOWER(Name)

Result:

Name: ajay kumar

Proper Case

The Proper case is text that is capitalized with the first letter of each word.

ex:

Create a calculator field for this: Name

UPPER(LEFT(SPLIT([Name],' ',1),1)) +

LOWER(MID(SPLIT([Name],' ',1),2,20)) +

' ' +

UPPER(LEFT(SPLIT([Name],' ',2),1)) +

LOWER(MID(SPLIT([Name],' ',2),2,20)) +

' ' +

UPPER(LEFT(SPLIT([Name],' ',3),1)) +

LOWER(MID(SPLIT([Name],' ',3),2,20))

Result:

Name: Ajay Kumar