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
om>>
> To: 4D iNug Technical <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>>
> Subject: identify duplicates
> Message-ID:
> <cae-8fqy9hmzfuptgxd0--cohhuu+diumg9ne6mlignduu_x...@mail.gmail.com
> <mailto:cae-8fqy9hmzfuptgxd0--cohhuu+diumg9ne6mlignduu_x
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
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
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
10 matches
Mail list logo