My thought on this would be to do the following:
1. EDIT-LIST list1
2. add "xx" at the end (this will force a @am to the end of your last select
list entry)
3. put the following DICT entry in the second file call it MULTIMATCH,
I
TRANS("&SAVEDLISTS&",listname,-1,'X') ; IF INDEX(@1,ATTR2:@vm,1)=0 THEN ""
ELSE "Y"
4. SELECT FILE2 WITH MULTIMATCH="Y"
Of course, you would need to do this for each savedlist you pull from list1
and...I'm not sure if that I-desc will work in Unidata.
George
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Noah Hart
Sent: Monday, July 25, 2005 12:47 PM
To: [email protected]
Subject: RE: [U2] [UD] Select on an attribute
Sharyl,
That works great if I want all the matches. My specific problem (which
I was not clear on before) is that I will only have a small number of ID
in my save list.
For example:
SELECT ALL CUSTOMERS in CALIFORNIA
SAVE-LIST CACUST
then I want to say
<PSEUDO CODE>
SELECT ALL INVOICES WITH CUSTOMER IN SAVE-LIST CACUST
Thanks,
Noah
-----Original Message-----
From: Sharyl Lindsay [mailto:[EMAIL PROTECTED]
Sent: Monday, July 25, 2005 8:22 AM
To: Noah Hart
Subject: RE: [U2] [UD] Select on an attribute
Hi Noah,
If I'm understanding you correctly, I'd do the following:
QSELECT FILE2 (1
SAVE-LIST xxLISTNAME
GET-LIST xxLISTNAME
SELECT FILE1
This will give you all the items in FILE1 that have the same value as
attribute two of FILE2.
Sharyl
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart
Sent: Monday, July 25, 2005 7:47 AM
To: [email protected]
Subject: [U2] [UD] Select on an attribute
Select question:
Assume that I have 2 files, such as customer and invoice
File1: has 1 attribute, ID
File2: has 2 attributes, ID and FILE1_ID
I have a savedlist with ID numbers from file1.
I want to select all records in file2 which have FILE1_ID matching the
savedlist I already have.
Is this possible?
Thank you,
Noah
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
