Need Distinct Values

[Mike Schwartz (PC Support)]

> On Behalf Of Kenneth Brody
>> Quoting Walter Vaughan (Tue, 16 Jan 2007 17:23:24 -0500):
> [...]
> > I have about 17K records with two fields, one 10 characters and one 2.
> > I need to create an xml export with unique values.
> >
> > Of course as you can see from the following code snippit, it's only good
> > for 2,666 values and I need seven times that.
> [...]
> >    3  -------   -   -   -   -   -   -   -   -
> >         . If: 'combine fields ala MK12-2345-89
> >         Then: pm=mid(1,"1","2"){6
> >    4  -------   -   -   -   -   -   -   -   -
> >         . If: zm co pm
> >         Then: end
> [...]
> > And as expected I am getting duplicate keys in my xml export since "ZM"
> > can't be made larger than 32K. The XML records are way wider than 255
> > characters so I can't use a report format.
> >
> > How else can you remove duplicate output data at runtime?
> 
> Can you sort on field 1 for length 2, and then field 6?  Any duplicates
> will then be in consecutive records.

     Along this same train of thought, can you run this as a report process,
suppressing blank lines, so that you can subtotal by the first field?  That
way, you could clear ZM at each subtotal, and not have to build PM at all.
You would just append field 6 to ZM.  That would allow you up to 3200
records in any one subtotal group, although you might want to put a ~ or
some other character between entries, so that you don't misinterpret the
numbers in ZM.  That would still allow you 2909 entries.

     I can think of several ways to get around the 3200 limitation, if you
think that will still be a problem.

Mike Schwartz