Re: identify duplicates

2017-11-01 Thread Reiner Kief via 4D_Tech
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

Re: identify duplicates

2017-11-01 Thread Janet Jonas via 4D_Tech
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

Re: identify duplicates

2017-11-01 Thread Chip Scheide via 4D_Tech
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

Re: identify duplicates

2017-11-01 Thread Arnaud de Montard via 4D_Tech
> 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

Re: identify duplicates

2017-10-31 Thread Keith Culotta via 4D_Tech
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 //

RE: identify duplicates

2017-10-31 Thread Tai Bui via 4D_Tech
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...@

Re: identify duplicates

2017-10-31 Thread npdennis via 4D_Tech
> 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

Re: identify duplicates

2017-10-31 Thread Chuck Miller via 4D_Tech
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

RE: identify duplicates

2017-10-31 Thread Tai Bui via 4D_Tech
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

identify duplicates

2017-10-31 Thread David Witton via 4D_Tech
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