-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Thursday, May 17, 2012 3:39 PM
To: 'U2 Users List'
Subject: [U2] SAVING UNIQUE ( multivalued)
Does anyone know a trick to achieve the equivalent of
SELECT filename SAVING
Another option, using UniVerse SQL to create the list:
SELECT DISTINCT column_name TO SLIST 0 FROM UNNEST filename ON column_name
[WHERE clause]
For example:
LIST rigtable005 GROUP_COL 01:46:32pm 18 May 2012 PAGE1
rigtable005 Group_col.
10 GROUP 2
GROUP 3
Nice,
Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Friday, May 18, 2012 6:48 AM
To: 'U2 Users List'
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
Another option, using UniVerse SQL
AM
*Subject:* Re: [U2] SAVING UNIQUE ( multivalued)
Nice,
Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Friday, May 18, 2012 6:48 AM
To: 'U2 Users List'
Subject: Re: [U2] SAVING UNIQUE
Does anyone know a trick to achieve the equivalent of
SELECT filename SAVING UNIQUE fieldname
When fieldname is the name of a multivalued field, and I want a list of all
the unique values for that field?
The syntax above does not explode the values, but just looks at the whole field.
I
@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
I found an old post that seemed to address this:
To do a SAVING UNIQUE with a mulit-valued field, you have to use
QSELECT and the field has to be an attribute number, not a dictionary name
Ex.
GET.LIST WORKING.IMOD.6 TO 1
-values, but it won't dedupe them.
-Original Message-
From: Rick Nuckolls r...@lynden.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Thu, May 17, 2012 1:06 pm
Subject: [U2] SAVING UNIQUE ( multivalued)
Does anyone know a trick to achieve the equivalent of
SELECT filename SAVING
as needed.
Chris
To: u2-users@listserver.u2ug.org
From: wjhon...@aol.com
Date: Thu, 17 May 2012 16:13:31 -0400
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
You have two issues.
One is to create a list from an exploded multi-value
The other issue, is to dedupe that list.
Without using
:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
I usually get my exploded list and then DEDUPE using the following:
LOCATE VALUE.TO.FIND IN UNIQUE.LIST BY AL SETTING POS ELSE
UNIQUE.LIST = INSERT(UNIQUE.LIST,1,POS,0,VALUE.TO.FIND)
END
This puts everything
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 1:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
I usually get my exploded list and then DEDUPE using the following:
LOCATE VALUE.TO.FIND
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Thursday, May 17, 2012 4:38 PM
To: 'U2 Users List'
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
This does present a challenge,
The following (non-portable solution works)
:ED
Date: Thu, 17 May 2012 15:47:11 -0500
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
What about ...
: P
0001: PA
0002: QSELECT C2,file
#0 is used)
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 5:00 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
That works
Users List
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
MERGE.LIST Sorts automatically,
The UNION does the DEDUPING
The 1 union 1 - says to union of list#1 with list#1 (itself)
Otherwise:
MERGE.LIST # ACTION # TO #
Where ACTION = (UNION, INTERSECT or DIFF)
And the TO # will save the results
: GET.LIST UNIQUE
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Thursday, May 17, 2012 4:38 PM
To: 'U2 Users List'
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
This does present
@listserver.u2ug.org
Date: Thu, 17 May 2012 16:06:10 -0500
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
Now thinking about it, I think MERGE.LIST always does sort and deduping
regardless of which ACTION you use.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users
Nuckolls
Sent: Thursday, May 17, 2012 5:07 PM
To: U2 Users List
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
UNION would definely be an alternative, but doing it against a needlessly long
second list offends my Scotch genes. It is possible to create an active, zero
length, selectlist
was excellent.
Chris
From: r...@lynden.com
To: u2-users@listserver.u2ug.org
Date: Thu, 17 May 2012 14:07:24 -0700
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
UNION would definely be an alternative, but doing it against a needlessly
long second list offends my Scotch genes
: Thursday, May 17, 2012 5:11 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
The description of UNION is a bit confusing with regards to the way this works:
UNION - list3 contains all elements from list1 and all elements from list2
that are not in list1
No worries, it all makes perfect sense now ;)
Thanks!
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Thu, 17 May 2012 16:16:25 -0500
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
I may have confused you when I said the UNION does the deduping - Sorry
...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, May 17, 2012 2:15 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
Rick,
I'm not following you.. There isn't a 'second list'.. it's one list that is
being manipulated (George's example only uses 1 list) which he
, and are for the
MERGE.LIST operation only.
-Rick
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Thursday, May 17, 2012 2:22 PM
To: 'U2 Users List'
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
I do not know the guts
-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Thursday, May 17, 2012 2:36 PM
To: 'U2 Users List'
Subject: Re: [U2] SAVING UNIQUE ( multivalued)
Okay, I timed the difference with 1,400,000 or so record ids on a relatively
old SUN box.
Union against an identical list 64930
23 matches
Mail list logo
