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.

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