Richard. Doesen't the tertiary output from Lookup contain what you desire? [Master records that are not matched by a detail.]
j. 2009/1/8 Schuh, Richard <[email protected]>: > I am trying to find a pipe solution to the following problem: > > I have 2 files that have tags in them. I want to identify which tags are > present in one of the files but not the other. A lookup would fill the > bill nicely, except for the fact that there may be more than one > occurrence of any given tag in either of the files. I want to do > something akin to a lookup allmasters and delete one occurrence from the > reference for each detail that matches. After all occurrences of a tag > have been deleted from the reference, any remaining tags in the detail > would be considered to be unmatched. Similarly, if not all masters were > matched and deleted, those that remain would be deemed unmatched. > > Is this something that can be done reasonably well. My brain has fogged > over (too many meetings, I think) so I have not seen the simple solution > that probably exists. > > Regards, > Richard Schuh >
