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

• The following fields in the data table:

  • InputText

  • NoOfChars

Load script

Example:
Load * inline [
InputText, NoOfChars
'abcdef', 3
'2021-07-14', 4
'2021-07-14', 2
];

Results

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

• InputText

• NoOfChars

Create the following calculated dimension:

• =Left(InputText,NoOfChars)

The first row returns abc, as these are the first 3 characters from the left of the string InputText.

The second row returns 20, as these are the first 2 characters from the left of the string InputText.

The third row returns 2021, as these are the first 4 characters from the left of the string InputText.

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

Example:
Load
*,
left(Text,NoOfChars) as Left;
Load * inline [
Text, NoOfChars
'abcdef', 3
'2021-07-14', 4
'2021-07-14', 2
];

Overview

This example parses the order codes in a dataset, which contain a region code, year, and order number, to create a new field for data analysis.

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:

  • OrderID

  • CustomerName

  • SalesAmount

Load script

Example:
Load * inline [
OrderID, CustomerName, SalesAmount
US2024001, John Doe, 1500
EU2024002, Jane Smith, 2300
AS2024003, Mike Davis, 1800
];

Results

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

• OrderID

• CustomerName

• SalesAmount

Create the following calculated dimension:

• =Left(OrderID, 2) to calculate the region.

The output from the Left function parses the OrderID to extract the region, creating a new field to use for further data analysis.

Overview

This example parses the product codes in a dataset, which contain a department category code and a unique identifier, to create a new field for data analysis.

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

Load script

Example:
Load * inline [
ProductCode
ELC12345
HOM67890
FAS09876
];

Results

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

• ProductCode

Create the following calculated dimension:

• =Pick(Match(left(ProductCode,3),'ELC','HOM','FAS'),'Electronics','Home Appliances','Fashion'), to calculate the department.

The output uses the Pick, Match, and Left functions to extract the department from the product code, creating a new field for data analysis.