What about comparing hashes?
> Am 31.10.2017 um 21:40 schrieb David Witton via 4D_Tech
> <4d_tech@lists.4d.com>:
> Does anyone have a suggestion on how to proceed?
Reiner Kief
Software & IT-Consulting
Weinbergstrasse 45
63853 Moemlingen
Germany
www.kief-online.de
Member of the german
Here is a strategy I have used since V6 to enforce a semi-informal primary key
for records in an important file. Another parameter was added when our business
changed a few years ago. I think you could make it work for your task:
C_BOOLEAN($0;$DupExists)
C_TEXT($2;$3;$Value1;$Value2)
One of the things others have mentioned, but have not really expounded
upon...
What constitutes a duplicate?
For an individual field this can be complex, for multiple fields...
For some data types (numerics) a duplicate is easy to define
2 = 2 = 2 = 2 (integer/long integer)
For others (text) it
> Le 31 oct. 2017 à 21:40, David Witton via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> 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
The third parameter of DISTINCT VALUES really saves work. Here is a strategy
to find dups in a field within a selection. The set can be a listbox highlight
set.
//
// Method: DuplicatesToSet
// -
// INPUT1: Pointer - field
//
day, 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 <t...@
> 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.
If you are just looking for fields that are exactly the same, the SQL with
GroupBy
As has been recommended distinct values is your friend but it really depends
upon what you mean by duplicates. For example Charles and Karl are the same
name but in different languages. So what do you mean by duplicates. Also is
case important or do able and Able equal each other
Regards
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.
-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David Witton
via 4D_Tech
Sent: Tuesday, October 31, 2017
9 matches
Mail list logo