Unique ID for character fields
Robert van den…
Forums
Is there a way to create a unique numeric field for several character fields? The reason is the benfords law analysis which tends to mark records as suspicious based on different criteria (first two digits, last two digits, second order and summation). For the user i want to combine the suspicious results but i want to eleminate double results.
Hi Robert,
Hi Robert,
The suspicous results contain the record number field. Just make sure that there are no duplicate record numbers in your combined suspicous file and you will eliminate any double results.
Brian