Kate,
This gives strange results if F1 is multi-valued so attribute 2
of the dict item needs to be: @1+SUM(F1)
Thanks,
Don Robinson
From: Kate Stanton k...@walstan.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tuesday, July 2, 2013 6:32 PM
Subject:
But correct me if I'm mistaking this, but doesn't this mean you need a special
extra dict entry for any column for which you want a running total? So if I
have a file with ten different fields that hold raw dollar amounts and I may
want a running total on any particular one of them, I would
Thanks, Don. I had not tried to use it with multi-values. Cheers, Kate
On 4 July 2013 01:54, Don Robinson donr_w...@yahoo.com wrote:
Kate,
This gives strange results if F1 is multi-valued so attribute 2
of the dict item needs to be: @1+SUM(F1)
Thanks,
Don Robinson
Can anyone explain this situation better. I've only ever used the @ to
simplify a few I-descriptors.
I have a dict item SIZE that is just the LEN(@RECORD)
So in this thread we've seen two EVAL solutions to a running total
LIST VOC SIZE EVAL @1+SIZE
LIST VOC SIZE EVAL SIZE + @2;@
In the first
I believe the expression in the second example is referred to as a compound
expression?
Can't put my finger on the exact documentation but I seem to recall that
compound expressions are broken up into parts (for want of a better term)
delimited by a ';' and each part can be referenced
I could only find doc for this in the System Description manual, where it
talks about using @ in I-type expressions, where @ is the previous one
(just resolved), @1 is result of first sentence (separated by ;), @2 is
result of 2nd sentence, etc. I could not see an example of using the
result from
You can also see what the I-type does by
DLIST yourfile yourdictitem
It's the equivalent of VLIST for I-Types...
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Thursday, 4 July 2013 9:48 AM