on 10-29-2015 8:33 PM
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.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.