r...@lynden.com
*To:* 'U2 Users List'
*Date:* 5/18/2012 11:35 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, M
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 UniVe
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
RD.
Tom
RATEX Business Solutions.
-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 3:39 PM
To: 'U2 Users List'
Subject: [U2] SAVING UNIQUE ( multivalued)
Does anyon
u2ug.org
[mailto:u2-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 a
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 kno
users-boun...@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&#
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 th
Sent: 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
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.
>From
.. I
thought George's solution 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 nee
Rick 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, selec
kegroup.com
> To: u2-users@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
-uo '&SAVEDLISTS&/UNIQUE' '&SAVEDLISTS&/UNIQUE'"
>
> 0005: GET.LIST UNIQUE
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
>
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
list #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
erver.u2ug.org
> Date: Thu, 17 May 2012 15:47:11 -0500
> Subject: Re: [U2] SAVING UNIQUE ( multivalued)
>
> What about ...
>
> : P
>
> 0001: PA
0005: 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 a cha
SAVE.LIST UNIQUE
0004: sh -c "/usr/bin/sort -uo '&SAVEDLISTS&/UNIQUE' '&SAVEDLISTS&/UNIQUE'"
0005: GET.LIST UNIQUE
> From: r...@lynden.com
> To: u2-users@listserver.u2ug.org
> Date: Thu, 17
sers-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 IN UNIQUE.LIST BY "AL"
through 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
> Th
multi-values, but it won't dedupe them.
-Original Message-
From: Rick Nuckolls
To: 'U2 Users List'
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 UNIQUE fieldname
Whe
@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
27; SAVING UNIQUE 4
SAVE.LIST GET.IMOD.ADDRESS
...
George
> From: r...@lynden.com
> To: u2-users@listserver.u2ug.org
> Date: Thu, 17 May 2012 12:39:09 -0700
> Subject: [U2] SAVING UNIQUE ( multivalued)
>
> Does anyone know a trick to achieve the equivalent of
>
> SELEC
als, Inc
w) 314 558 1482
d...@pickpro.com
-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:39 PM
To: 'U2 Users List'
Subject: [U2] SAVING UNIQUE ( multivalued)
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 supp
26 matches
Mail list logo
