Try:
LIST FILE1 EVAL "TRANS(FILE2,@RECORD<1,DCOUNT(@RECORD<1>,@VM)>,'12','X')"
Richard Lewis
On Fri, May 21, 2010 at 10:15 AM, James Patrick Volkman <
jamesvolk...@yahoo.com> wrote:
> I'm attempting to do a translate and was wondering if anyone might have a
> suggestion.
>
> Attribute (or Fiel
y, May 21, 2010 9:15 AM
To: u2-users@listserver.u2ug.org
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.
whether that is multi-valued or not.
Best regards
Colin.
- Original Message -
From: "James Patrick Volkman"
To:
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 anyo
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