Bob,
Hey, that was fun! I got this one to work:
U2UG.TEST
0001 I
0002
SUM(MULS(EQS(RAISE(TRANS("FILE2",OCONV(@ID,"G1*1"),1,"X")),REUSE(OCONV(@
ID,"G3*1"))),RAISE(TRANS("FILE2",OCONV(@ID,"G1*1"),2,"X"))))
0003
0004
0005 10L
0006 M
It gets <1> from file2, using "G1*1" of the key from file 1,
compares the multivalues to "G3*1" of the file1 key, which results in a
MV'd list of 0 and 1, with the only "1" corresponding to the MV in
file2<1> that matches. Then gets <2> from file2, and MULS them
together, and sums the results. What you get is 1 * the matching
qty-per-uom value from file2.
Give it a whirl, and see if it works for you. It's pretty nasty
to modify, so a program may be a better solution in the end....
--Ron Pingilley
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Friday, February 03, 2006 2:19 PM
To: [email protected]
Subject: [U2] UV I-descriptor
Hi Peoples,
<snip>
FILE1 @ID = "01*11223344*W1*EA"
FILE2 @ID = "11223344"
<5> = "CS^SP^EA"
<9> = "1^2^12"
I'm needing to get "12" back to the I-DESC in FILE1, again, hopefully
without having to resort to a called basic program.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
