Loading

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

發佈日期: Apr 13, 2024
工作
How to convert only the first character of data to uppercase and the second and subsequent character to lowercase.

User-added image
步驟
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
知識文章編號

001463670

附件

test.xlsx

8 KB

Book.twbx

18 KB

 
正在載入
Salesforce Help | Article