Loading

Convert only the first character of data to uppercase and the second and subsequent character to lowercase in Tableau Desktop

Data pubblicazione: Apr 13, 2024
Operazione
How to convert only the first character of data to uppercase and the second and subsequent character to lowercase.

User-added image
Fasi
The following solution is demonstrated in the attached packaged workbook.

1. Connect to the attached sample data source 'test.xlsx' from Tableau Desktop.
2. Drag Name to Rows.
3. Create a new calculated field with the following definition:
      Name : Name (Converted)
      Calculation : UPPER(LEFT([Name],1)) + LOWER(MID([Name],2))
4. Drag Name (Converted) to Rows next to Name.
User-added image
Numero articolo Knowledge

001463670

Allegati

test.xlsx

8 KB

Book.twbx

18 KB

 
Caricamento
Salesforce Help | Article