Unique ID for character fields

2 posts / 0 new
Last post
Robert van den ...
Offline
Joined: 08/08/2018 - 07:37
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's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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