Need Distinct Values
Walter Vaughan
wvaughan at steelerubber.com
Tue Jan 16 14:23:24 PST 2007
I cannot believe I cannot figure this out.
I need unique distinct values. I've done this a million times, but with a
smaller number of items, using a dummy field to determine and toss out dupes.
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.
1 ------- - - - - - - - -
. If:
Then: export ascii dec=/tmp/test3.xml
2 ------- - - - - - - - -
. If: 6 eq ""
Then: end
3 ------- - - - - - - - -
. If: 'combine fields ala MK12-2345-89
Then: pm=mid(1,"1","2"){6
4 ------- - - - - - - - -
. If: zm co pm
Then: end
5 ------- - - - - - - - -
. If:
Then: zm(32000,*,g)=zm{pm{"";
6 ------- - - - - - - - -
xmlmake. If: 'start building the export
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?
--
Walter
More information about the Filepro-list
mailing list