Ord 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.

• The following fields in the data table:

  • Chinese

  • Western

Load script

Example:
Load * inline [
Chinese, Western
古琴, Guqin
];

Results

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

• Chinese

• Western

Create the following calculated dimensions:

• =ord(Chinese), to return the numeric value of the value in the field named Chinese.

• =ord(Western), to return the numeric value of the value in the filed named Western.

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

Example:
Load *,
ord(Chinese) as OrdUnicode,
ord(Western) as OrdASCII;
Load * inline [
Chinese, Western
古琴, Guqin ];

Overview

A dataset of product codes includes some codes that are considered invalid because they start with a special character instead of an alpha-numeric one. Using the Ord function to identify the invalid product codes, a new measure is created to label the records either Valid or Invalid.

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

The load script contains:

• A dataset which is loaded in a data table called Products.

• One field in the data table called ProductCode.

Load script

Products:
Load * inline [
ProductCode
AB123
#EX45
12XY9
DEF456
*KLM78
GH789
];

Results

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

• ProductCode

Create the following calculated dimensions:

• =Ord(ProductCode), to return the numeric value of the first character.

• =If(Ord(ProductCode) < 48 OR (Ord(ProductCode) > 57 AND Ord(ProductCode) < 65) OR Ord(ProductCode) > 122, 'Invalid Product Code', 'Valid Product Code'), to check if the ordinal value of the code is alphanumeric. If it is not then that record is flagged as Not Valid.

Comparing the output of the Ord function to a range of valid alphanumeric values, you can determine which product codes are not valid.