check duplicate paid

sagaraperera — Thu, 14 May 2015 03:11:11 GMT

I want check duplicate claim paid in same amount of one claim no in several times.

sagara

Re: check duplicate paid

maxgro — Wed, 08 Jul 2015 16:23:23 GMT

in script you can use a group by claim (CLNO?) and amount ([CLAIM PAID]?) to check if the same amount was paid for the same claim in distinct dates

load CLNO, [CLAIM PAID], count(distinct DATE)

resident yourtable

group by CLNO, [CLAIM PAID]