Is Unique function not supported in data intelligence

[michael_eaton3]

sap-di-is-unique-function.jpg

Hello Everyone,

We are trying to develop a data quality rule for uniqueness dimension using Is_unique function in data intelligence. However, we are getting an error message (attached) stating this function is not supported in DI. Please help with some workaround.

Thanks in advance.

[michael_eaton3]

What version are you using? I just tried on SAP DI Cloud and it worked.

[former_member735308]

DI version 3.1.29 on prem.

[amish1980_95]

Hello,

is_unique is not avalibale on SAP Data Intelligence trial edition 3.1 as well.

Thanks,

Indu.

[michael_eaton3]

Hello

Use the exists function.

exists(<connection name>, <table name>, <comparison column>, <parameter or value the compare column will test>)

Michael

[former_member735308]

Hi Michael.

The exists function works well for comparing one column. Is there any way we can compare uniqueness of combination of two or more columns. For instance, one customer should have one mobile number. In this case, we need to compare the uniqueness of customer id and mobile number.

Many thanks for your support.

[michael_eaton3]

One technique is to concatenate the source columns first, then you can compare them to a single concatenated value.

[bharathkote]

How can we use for loop in the scripting? pls provide the syntax