Menu
Amazon QuickSight
User Guide

toLower Function

toLower formats a string in all lowercase. toLower skips rows containing null values.

Syntax

Copy
toLower(expression)

Arguments

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

Return Type

String

Example

The following example converts a string value into lowercase.

Copy
toLower('Seattle Store#14')

The following value is returned:

Copy
seattle store#14