I Don't know if Unidata is the same as Universe for this but... To do a SAVING UNIQUE with a mulit-valued field, you have to use QSELECT and the field has to be an attribute number, not a dictionary name
Ex. GET.LIST WORKING.IMOD.6 TO 1 QSELECT ADDRESS WITH ADDRESS.CHANGE.DATE GE ':X.CHG.DATE:' SAVING UNIQUE 4 SAVE.LIST GET.IMOD.ADDRESS ... George -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Thompson Sent: Friday, April 06, 2012 8:48 AM To: U2 Users List Subject: Re: [U2] Unwanted Duplicated If this is Universe I would say look for some option somewhere that is not set. Perhaps it behaves differently between account flavors. For example, in a BASIC program in a PICK flavor account, in order to use multiple SELECT lists you have to put $OPTIONS -x (I think) at the top on the program. Shot in the dark. On 4/5/12, Greg Coelho <[email protected]> wrote: > Hey Guys, > > I am selecting SAVING UNIQUE on a multivalue field. I then MERGE.LIST > these ID's with a larger group - which should itself only return Unique > ID's. What I am getting returned is a sizeable number of duplicates. > Looking closer it appears that these ID's are often attached to a value > marker which suggests that they were sitting with a Null Value that was > pulled in with the ID. > > 'GET.LIST WORKING.IMOD.6 TO 1' > 'SELECT ADDRESS WITH ADDRESS.CHANGE.DATE GE ':X.CHG.DATE:' SAVING UNIQUE > RESIDENTS' > 'SAVE.LIST GET.IMOD.ADDRESS' > 'GET.LIST GET.IMOD.ADDRESS TO 2' > 'MERGE.LIST 1 UNION 2 TO 3' > 'SAVE.LIST WORKING.IMOD.7 FROM 3' > > *** WORKING.IMOD.7 is full of dups! > > I was thinking about trying - > > SELECT ADDRESS WITH ADDRESS.CHANGE.DATE GE ':X.CHG.DATE:' SAVING UNIQUE > RESIDENTS NO.NULLS' > > Any recommendations? > > As Aways - Thanks! > > Greg > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- Sent from my mobile device John Thompson _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
