A challenge: Finding duplicates within a found set! 
Author Message
 A challenge: Finding duplicates within a found set!

How can I remove such duplication from within the found set?  We need to keep
the duplicates in the database because otherwise we wouldn't know what shows
each patron had seen.

Summarize by Customer Number. For example, you can create a report with no
"body" part/ sort by CustomerNum, using ONLY a subsummary part, on which you
place your fields.  Or you can sort by CustomerNum, export, summize by
CustomerNum.



Wed, 07 Mar 2001 03:00:00 GMT
 A challenge: Finding duplicates within a found set!


writes:

Quote:
>Say we want to send a special offer to everyone who saw either Hamlet or
>Macbeth or both.  Using the standard find functionality we can get a list of
>everyone who bought tickets for these shows.  But if someone bought tickets
>independently for both shows their name will show up twice, and they would
>get two mailshots.

>How can I remove such duplication from within the found set?  We need to keep
>the duplicates in the database because otherwise we wouldn't know what shows
>each patron had seen.

If all you want is a list, you can do it with a standard report that has a
subsummary based on whatever you are using to establish duplication. Just put
all the relevant info in the subsummary header, and delete the body entirely.
Run it after you sort on the same field that the subsummary is on.
Steve Andrews
Andrews Technologies Management


Wed, 07 Mar 2001 03:00:00 GMT
 A challenge: Finding duplicates within a found set!

writes:

Quote:
>Say we want to send a special offer to everyone who saw either Hamlet or
>Macbeth or both.  Using the standard find functionality we can get a list of
>everyone who bought tickets for these shows.  But if someone bought tickets
>independently for both shows their name will show up twice, and they would
>get two mailshots.

>How can I remove such duplication from within the found set?  We need to keep
>the duplicates in the database because otherwise we wouldn't know what shows
>each patron had seen.

If all you want is a list, you can do it with a standard report that has a
subsummary based on whatever you are using to establish duplication. Just put
all the relevant info in the subsummary header, and delete the body entirely.
Run it after you sort on the same field that the subsummary is on.
Steve Andrews
Andrews Technologies Management


Wed, 07 Mar 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Find duplicate words within a field?

2. Finding duplicate records within the same file.

3. FMP 5 - FIND within a FIND

4. Find First, Find Next, Find Previous, Find Last

5. Finding Duplicate Sets

6. CDML Next and Previous Button within a found set

7. How to Search within a found set

8. Search within already found set

9. Duplicate found set

10. Duplicating a found set ??

11. "FIND" on Found Set

12. Long Search Times\Find again on found set


 
Powered by phpBB® Forum Software