Rule specification assets

Back Next

Combining data values in advanced mode

To combine two or more data values in your data set, use the || operator. The operator combines the data values that you require into a single string.

For example, your organization might combine values to generate unique identifiers or keys. You might concatenate relevant attributes in your data set, such as a customer ID and an order ID to create a composite key that ensures unique identification of a data value.

Open a rule specification in advanced mode.

Verify that the rule specification contains the inputs and outputs that you require.

If the rule specification does not contain an input and an output that you can use, create an input and output. Configure the input and output properties to represent the type of column that contains the business data.

In the rule editor, type the

element of the IF-THEN-ELSE statement.

To specify the input, type the input name.

Enter the input value. For example, enter

12345

Enter an operator value. For example, enter the

AND

value to connect the inputs.

To specify another input, type the input name.

Enter the input value. For example, enter

1111

Type the

THEN

element.

To specify the output, type the output name.

Enter an operator value. For example, enter the

value to write a value for the data that satisfies the rule logic.

Enter the input names and use the

operator between the inputs to combine the values in the inputs.

Type the

ENDIF

element.

The following example shows the use of concatenate operator:

IF (Input = "12345" AND Input1 = "1111") 
	THEN 
		Output = (Input || Input1) 
ENDIF

Business rules and rule statements

Download Guide

Watch

Comments

Cloud Data Quality Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Rule specification assets

Rule specification assets

Combining data values in advanced mode

Combining data values in advanced mode