Lower - script and chart function

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset which is loaded into a data table called Example.

• One field in the data table called InputText.

Load script

Example:
Load * inline [
InputText
rHode iSland
washingTon d.C.
new york
];

Results

Load the data and open a sheet. Create a new table and add this field as a dimension:

• InputText

Create the following calculated dimension:

• =Lower(InputText) to convert all characters in the InputText field to lowercase.

The output of the Lower function converts all values to lowercase.

The following code shows how to use the function in a load script.

Load
String,
Lower(String)
Inline
[String
rHode iSland
washingTon d.C.
new york];

Overview

A dataset of customer data contains email addresses with mixed-case characters for the domain. The company wants to standardize these addresses to use all lowercase.

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset which is loaded into a data table called Example.

• The following fields in the data table:

  • CustomerID

  • EmailAddress

  • Inquiry

Load script

Example:
Load * inline [
CustomerID,	EmailAddress, Inquiry
1001,john.doe@Gmail.com, Inquiry about product return
1002,mary.jane@yahoo.com, Inquiry about order status
1003,a.smith@GMAIL.COM, Inquiry about shipping details
1004,lisa.black@outlook.com, General product inquiry
1005,james.wong@Yahoo.COM, Question about pricing
];

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• CustomerID

• EmailAddress

Create the following calculated dimension:

• =Lower(EmailAddress) to separate the domain part of the email as a new column and convert the characters to lowercase.

The output of the Lower function returns all email addresses in lowercase.