Built-in Functions → caseContains

caseContains() is a conditional statement that returns a specified string value if the input field contains the specified string, else returns another string value.

Note

Use the caseContains() function to return a case sensitive string value.

Signature

caseContains(string field, string caseValue, string thenValue, ..., string elseValue)

The following table illustrates the caseContains() conditional statement parameters:

Parameter	Description
string field	The input field value to compare
string caseValue	The value compared against the `string field` value
string thenValue	The value returned as a result of matching codes, if the `string field` value contains the `string caseValue`
string elseValue	The value returned as a result of non-matching codes, if the `string field` value does not contain the `string caseValue`

Returns

String representing the thenValue and elseValue in the column.

Example

This example maps the regions that contain “As” with “Asia”, and maps all other regions with "Other”.

caseContains(
SALES.COUNTRIES.COUNTRY_REGION, 
"As", 
"Asia", 
"Other"
)

Use the following steps for detailed instructions on how to use the caseContains() conditional statement:

Note

In the Cluster Management Console (CMC), you can create a tenant that includes Sample Data. The Sample Data includes the SALES schema.

In the Navigation bar, select the Content tab, and then select + New → Add Dashboard.
In the Add Dashboard dialog, for Name, enter Product Dashboard, and then select Add.
In the Action bar, select + (add icon), or select + Add Insight.
In the Insight panel, select Listing Table or V.
In Tables, select Aggregated Table.
In the Datapanel, select Manage Dataset (+).
In the Manage Data Sets panel, in Tables, select SALES. Close the panel.
From the Data panel, drag and drop the following columns to the respective tray:
- Revenue from the SALES table to the Measure tray
- Region from the COUNTRIES table to the Grouping Dimension tray
From the Data panel, drag and drop Add Formula to the Grouping Dimension tray.
The Formula Builder automatically opens:
- In Search Functions, select the down arrow, and then select Conditional Statements.
- Double-click the first caseContains function, caseContains(string field, string caseValue, string thenValue, ..., string elseValue), to add the formula to the editor.
- In the Formula Editor,
  - Replace string field with Region from the Data panel
  - Replace string caseValue with “As”**
  - Replace string thenValue with “Asia”**
  - Replace string elseValue with “Other”

caseContains(SALES.COUNTRIES.COUNTRY_REGION, "As", "Asia", "Other")

Select Validate & Save.
In the Properties panel, for Column Label, enter caseContains()
Name the insight Revenue Per Region.
In the Action bar, select Save.

Content

Signature

Returns

Example