cancel
Showing results for 
Search instead for 
Did you mean: 

Rule for duplicate data

Former Member
0 Kudos

Hi

I need to create a rule for testing the duplicate vendors in a table.

The evaluation must take the Tax ID number of the vendors and test if there are more of one vendor with the same Tax ID number.

I tried to use the sentence "unique" inside the Advanced editor, but didn't work.

Can you help me with this rule?

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

former_member187605
Active Contributor
0 Kudos

In the advanced rule editor:

DECLARE

BEGIN

   RETURN is_unique($CandidateKey);

END

and bind to the TaxID column.

The result will be 0 (when duplicates) or 1 (when all distinctTaxID values).

Former Member
0 Kudos

Thanks Dirk!

Your answers was helpful!

Answers (0)