Search

Search Scripts

Scripting Reference Guides

Rick W
/ Categories: Tableau, Text Functions

Tableau SQL Text Functions

Text Functions within Tableau.

A. CONCAT:
Full Name = [First Name] + ' ' + [Last Name]

This example concatenates the First Name and Last Name columns in the Customer table, resulting in a single string representing the customer's full name.

B. LEFT:
First Initial = LEFT([Name], 1)

This example returns the first character from the Name column in the Employee table, providing the employee's first initial.

C. RIGHT:
Last Two Digits = RIGHT([Invoice Number], 2)

This example returns the last two characters from the Invoice Number column in the Sales table, extracting the last two digits.

D. MID:
Order Code = MID([Order Number], 3, 4)

This example returns a substring of four characters starting from the third character of the Order Number column in the Orders table.

E. UPPER:
Capitalized Country = UPPER([Country])

This example converts the Country column in the Location table to uppercase, providing the country name in capital letters.

F. LOWER:
Lowercase Text = LOWER([Description])

This example converts the Description column in the Notes table to lowercase, providing the text in lowercase letters.

Previous Article Tableau SQL Mathematical Functions
Next Article Tableau SQL Information Functions
Print
216