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 |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.