Upper Script and chart function

Overview

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

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:

• =Upper(InputText), to convert all the characters in the InputText field to uppercase.

The output of the Upper function converts all values to uppercase.

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

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

Overview

A dataset contains ISO country codes and country names in various formats, such as all lowercase, all uppercase, or mixed case. The objective is to clean the data so that each country code and name are formatted to use uppercase.

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

The load script contains:

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

• The following fields in the data table:

  • ISO CountryCode

  • CountryName

Load script

Country:
Load  * inline [
​​ISO_CountryCode, CountryName
gbr, United kingdom
Ind, india
CAN, Canada
Are, United arab emirates
];

Results

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

• ISO_CountryCode

• CountryName

Create the following calculated dimensions:

• =Upper(ISO_CountryCode), to create a column of country codes that use all uppercase characters.

• =Upper(CountryName), to create a column of country names that use all uppercase characters.

The Upper function has converted all country codes and country names to use uppercase characters.

Overview

Using the same dataset as the previous scenario, this example combines country name and country code and formats these strings using the Capitalize and Upper functions.

Result

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

• ISO_CountryCode

• CountryName

Create the following calculated dimension:

• =Capitalize(CountryName) & ' (' & Upper(ISO_CountryCode) & ')', to create a new dimension that concatenates CountryName and ISO_CountryCode and formats the country names to use title case and the country codes to use uppercase.