Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 30, 2015 at 08:49 AM

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

    Add comment
    10|10000 characters needed characters exceeded