Re: [U2] Unwanted Duplicated

2012-04-09 Thread George Gallen
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:'

Re: [U2] Unwanted Duplicates

2012-04-09 Thread Shaun.Ferguson
Use the UNION keyword in MERGE.LIST. GET.LIST LIST 1 TO 1 GET.LIST LIST2 TO 2 MERGE.LIST 1 UNION 2 If you are using UniData, use ECLTYPE U not ECLTYPE P. get.list LIST1 TO 1 get.list LIST2 TO 2 merge.list 1 UNION 2 From HELP: Note: UniQuery only supports MERGE.LIST is in ECLTYPE U. Note: The