Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Rule for duplicate data

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.

Former Member
replied

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

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question