Hi James.
To do it in a dictionary item you just need a correlative (derived field,
I-descriptor) defined within FILE1 whish contains the following:
F;1;(TFILE2;X;;12)
This will list whatever is in attribute <12> of FILE2 using the value in
attribute <1> of FILE1 as the key - whether that is multi-valued or not.
Best regards
Colin.
----- Original Message -----
From: "James Patrick Volkman" <[email protected]>
To: <[email protected]>
Sent: Friday, May 21, 2010 5:15 PM
Subject: [U2] TRANSLATING LAST VALUE FROM A SINGLE VALUE
I'm attempting to do a translate and was wondering if anyone might have a
suggestion.
Attribute (or Field) 1 of File1 is a multi-valued foreign key to the
Primary Key in File2. File2 contains a Date in Attribute 12. I want the
latest date in Attribute 12 of File2 of all the values of Attribute 1 in
File1.
This is pulling 1 record from Attribute 1 of File1. How can I display the
Date (Attribute 12 of File2)?
LIST FILE1 1 EVAL
"@RECORD<1,DCOUNT(TRANS(FILE2,@RECORD<1>,'12','X'),@VM)>"
Jim Volkman
http://www.linkedin.com/in/jamesvolkman
_______________________________________________
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
