Hi David,
Perhaps using GROUP BY like Neil suggested in an SQL call in a similar fashion
to the following will help:
Begin SQL
SELECT tbl.fld_1,tbl.fld_2,tbl.fld_3,Count(*) AS recCount
FROM tbl
GROUP BY tbl.fld_1,tbl.fld_2,tbl.fld_3
HAVING Count(*)>1
INTO :$arrFld1,:$arrFld2,:$arrFld3,:$arrCount;
End SQL
The size of the arrays show how many “DISTINCT” set up duplicates you have and
the ones in the same element position show the values and the Count of
duplicates found.
Best Regards,
-Tai B.
From: David Witton [mailto:[email protected]]
Sent: Tuesday, October 31, 2017 2:07 PM
To: Tai Bui
Subject: Re: identify duplicates
It helps with the single field problem - now I'm trying to solve the multiple
field problem without creating a new field for each combination of fields I
want to examine.
On Tue, Oct 31, 2017 at 2:43 PM, Tai Bui <[email protected]<mailto:[email protected]>>
wrote:
Hi David,
Would the DISTINCT VALUES command help?
http://doc.4d.com/4Dv16R4/4D/16-R4/DISTINCT-VALUES.301-3317277.en.html
Best Regards,
-Tai B.
Tai Bui
Technical Services Engineer
4D Inc
95 S. Market Street, Suite #240
San Jose,CA 95113
United States
Telephone: +1-408-557-4600<tel:%2B1-408-557-4600>
Fax: +1-408-271-5080<tel:%2B1-408-271-5080>
Email: [email protected]<mailto:[email protected]>
Web: www.4d.com<http://www.4d.com>
-----Original Message-----
From: 4D_Tech
[mailto:[email protected]<mailto:[email protected]>] On
Behalf Of David Witton via 4D_Tech
Sent: Tuesday, October 31, 2017 1:41 PM
To: 4D iNug Technical
Cc: David Witton
Subject: identify duplicates
I'm looking for a strategy to identify duplicate records in a table - that is,
records for which 3 fields are identical across two or more records - or in
another case, where a single field is not unique.
Does anyone have a suggestion on how to proceed?
--
David Witton
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:
mailto:[email protected]<mailto:[email protected]>
**********************************************************************
--
David Witton
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
