I am gratified that Dawn and Mark found my silly question amusing.
Newbies need to understand the central role of dynamic arrays in the
multi-value uniVerse.
An excellent place to go is to the world of the author, Malcolm Bull.
--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
Think of a multi-valued column as a single-column nested table. If you prefer,
a cell whose data type is 'table'. This is a simple enough concept in XML; the
Pick model has had it since the 1960's!
The sum of all elements in a multi-valued column is given by the SUM() function
if there are
Q2:Use matparse cf. basic manual - has examples.
-- mats
Sanjeebkumar Sarangi skrev:
Hi,
Suppose, I have a multivalue column. How can I get the sum of all
the values ? If I want to create an array of the elements present in the
multivalue column, then how can I do it ? Please
- Original Message -
From: Brutzman, Bill [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, April 17, 2007 11:50 AM
Subject: RE: [U2] Multivalue Column
What's a multivalue column?
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
Sanjeeb,
TOTAL will total. Look in the manuals for Retrieve. There's a lot to
be gained by going through them.
- Chuck
Sanjeebkumar Sarangi wrote:
Suppose, I have a multivalue column. How can I get the sum of all the values ?
If I want to create an array of the elements present in
Sanjeebkumar Sarangi wrote:
Hi,
Suppose, I have a multivalue column. How can I get the sum of all
the values ? If I want to create an array of the elements present in the
multivalue column, then how can I do it ? Please give me some examples.
Thanks,
Sanjeeb
You might try asking
What's a multivalue column?
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Sanjeebkumar
Sarangi
Sent: Tuesday, April 17, 2007 10:12 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Multivalue Column
Hi,
Suppose, I have a multivalue
I could be missing something, but to display the multi's, build an
i-descriptor that looks like these column heads for S1 and SS2.
LIST BIG.INDEX TOTAL F2 TOTAL S1 TOTAL SS2 02:02:03pm 17 Apr 2007 PAGE1
BIG.INDEX. F2 SUM(F2)... SUM(SUM(F2))
TEST13317
That looks really cool, eh?
On 4/17/07, john reid [EMAIL PROTECTED] wrote:
I could be missing something, but to display the multi's, build an
i-descriptor that looks like these column heads for S1 and SS2.
LIST BIG.INDEX TOTAL F2 TOTAL S1 TOTAL SS2 02:02:03pm 17 Apr 2007 PAGE1
My company can provide assistance.
Allen Egerton [EMAIL PROTECTED] wrote: Sanjeebkumar Sarangi wrote:
Hi,
Suppose, I have a multivalue column. How can I get the sum of all
the values ? If I want to create an array of the elements present in the
multivalue column, then how can I do it ?
Use an I descriptor and the sum syntax
Dave R
e Fax (815)4259364
P.O. Box 17811, Irvine CA 92623-7811
-- Brutzman, Bill [EMAIL PROTECTED] wrote:
What's a multivalue column?
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Sanjeebkumar
Sarangi
My company can help.
Tom Dodds InformCorp, LLC Information for Corporations
[EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar
Sarangi
Sent: Tuesday, April 17,
Laughing.
Yes, you get columns in tables where there are rows, but attributes or
fields in files with records or items. A multi-valued column is a
mixture of terms. On the other hand, a multivalue column could be a
multi-valued attribute (let's call it MVATTR) in an sql-ized file in
U2 (we will
13 matches
Mail list logo