Skip to main content

Unique ID for character fields

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.  

Brian Element Fri, 12/28/2018 - 16:58

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