: Tuesday, September 11, 2012 11:49 AM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table
SPLICE ... now THAT'S a cool little tool! I'll have to do some testing
with null attributes and values, but this just may work!
Thank you Rex and Stuart!
Sincerely,
David Laansma
---
r.u2ug.org] On Behalf Of Rex Gozar
Sent: Tuesday, September 11, 2012 1:08 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table
Not a function, but there are some subroutines that "flip" posted on
PickWiki:
http://www.pickwiki.com/cgi-bin/wiki.pl?Row2Col
AND
http://www.
Not a function, but there are some subroutines that "flip" posted on PickWiki:
http://www.pickwiki.com/cgi-bin/wiki.pl?Row2Col
AND
http://www.pickwiki.com/cgi-bin/wiki.pl?Row2Col_II
rex
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://lis
Sent: Tuesday, 11 September 2012 6:32 AM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table
:-)
Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative S
* OPT 1: a little quicker than nested for..next (depending on how many)
xx = dcount(array<1>,@vm)
for x = 1 to xx
newarr<-1> = array<1,x>:@vm:array<2,x>
next x
OR
* OPT 2: the fastest...(cos it maintains a file pos pointer)
arr1 = array<1>
arr2
users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, September 10, 2012 4:31 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table
Why is the Kink's song Lola suddenly playing in my mind!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailt
rting/Pivoting a table
Columns become rows
Rows become columns
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Columns become rows
Rows become columns
We call them attributes and item-ids, but it's the same difference
-Original Message-
From: Dave Laansma
To: U2 Users List
Sent: Mon, Sep 10, 2012 1:12 pm
Subject: Re: [U2] Inverting/Pivoting a table
Excerpt from page 1-161 o
f Wjhonson
Sent: Monday, September 10, 2012 4:02 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Inverting/Pivoting a table
EXECUTE "REFORMAT"
it doesn't copy, it changes the format as well in other words, it
pivots, as you asked
-Original Message-
From: Dave L
EXECUTE "REFORMAT"
it doesn't copy, it changes the format as well
in other words, it pivots, as you asked
-Original Message-
From: Dave Laansma
To: U2 Users List
Sent: Mon, Sep 10, 2012 12:59 pm
Subject: Re: [U2] Inverting/Pivoting a table
REFORMAT appears t
-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Monday, September 10, 2012 3:41 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table
REFORMAT is a TCL command.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.or
REFORMAT is a TCL command.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: September-10-12 12:39 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table
REFORMAT perhaps?
I am find no
--Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, September 10, 2012 2:20 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Inverting/Pivoting a table
REFOMAT
-Original Message-
From: Wols
REFOMAT
-Original Message-
From: Wols Lists
To: u2-users
Sent: Mon, Sep 10, 2012 11:07 am
Subject: Re: [U2] Inverting/Pivoting a table
On 10/09/12 14:39, Dave Laansma wrote:
> I get flat files that I'd like to 'flip' to accommodate the multi-value
> databas
On 10/09/12 14:39, Dave Laansma wrote:
> I get flat files that I'd like to 'flip' to accommodate the multi-value
> database. For example, given this table:
>
I thought there was a command that would flip a FILE like that. I've
never used it, but I recall a colleague making good use of it ...
>
>
I get flat files that I'd like to 'flip' to accommodate the multi-value
database. For example, given this table:
123456DAVID JONES1234 MAIN ST.ANYWHEREMI12345
654321JOHN SMITH4321 MAIN ST.ANYWHEREMI12345
Is there a function that will change it to:
123456654321
DAVID JONESJOHN SMITH
1
16 matches
Mail list logo