ArjunK wrote:You can remove dups on all four keys and then just aggregate on all four. Where ever the count is greater than 1 set record as 'MULTIPLE'.
If you remove duplicates, you cannot have multiple. So the count will not be more than 1.
ArjunK wrote:You can remove dups on all four keys and then just aggregate on all four. Where ever the count is greater than 1 set record as 'MULTIPLE'.
If you remove duplicates, you cannot have multiple. So the count will not be more than 1.
My bad. Remove duplicates of four and then aggregeate on the first three.