f=: 13 :'18 2$,( ,.{."1 }."2 y),"1 0 }."1 }."2 y'
Linda
-Original Message-
From: Programming [mailto:[email protected]] On Behalf
Of Joe Bogner
Sent: Thursday, March 17, 2016 10:45 PM
To: [email protected]
Subject: [Jprog
;@:(<@({. ,. }.)"1)
Untested.
Henry Rich
On 3/17/2016 10:44 PM, Joe Bogner wrote:
Is there a simple or efficient transform of
tbl =: ' ' cut every LF cut (0 : 0)
id col1 col2 col3 col4 col5 col6
1 ab cd ef gh hi jk
2 lm no pq rs tu vw
3 xy zz aa bb cc dd
)
+--+++++++
Original Message-
> From: Programming [mailto:[email protected]] On
> Behalf Of Henry Rich
> Sent: Thursday, March 17, 2016 10:55 PM
> To: Programming forum
> Subject: Re: [Jprogramming] transform table columns to rows
>
> Your table is regular,
Linda
-Original
-Original Message-
From: Programming [mailto:[email protected]] On Behalf
Of Joe Bogner
Sent: Friday, March 18, 2016 1:39 PM
To: [email protected]
Subject: Re: [Jprogramming] transform table columns to rows
Solutions like this remind me
Re: [Jprogramming] transform table columns to rows
Henry, Your result has 24 rows.
Linda
-Original Message-
From: Programming [mailto:[email protected]] On Behalf
Of Henry Rich
Sent: Thursday, March 17, 2016 10:55 PM
To: Programming forum
Subject: Re: [Jprogrammi
outstanding! thank you
On Thu, Mar 17, 2016 at 10:54 PM, Henry Rich wrote:
> Your table is regular, so
>
> ,/@:(({. ,. }.)"1)
>
> would also work.
>
> Henry Rich
>
>
> On 3/17/2016 10:47 PM, Henry Rich wrote:
>
>> ;@:(<@({. ,. }.)"1)
>>
>> Untested.
>>
>> Henry Rich
>>
>> On 3/17/2016 10:44 PM,
Your table is regular, so
,/@:(({. ,. }.)"1)
would also work.
Henry Rich
On 3/17/2016 10:47 PM, Henry Rich wrote:
;@:(<@({. ,. }.)"1)
Untested.
Henry Rich
On 3/17/2016 10:44 PM, Joe Bogner wrote:
Is there a simple or efficient transform of
tbl =: ' ' cut every LF cut (0 : 0)
id col1 col2
Linda
-Original Message-
From: Programming [mailto:[email protected]] On Behalf
Of Joe Bogner
Sent: Friday, March 18, 2016 1:39 PM
To: [email protected]
Subject: Re: [Jprogramming] transform table columns to rows
Solutions like this remind me how grateful
Solutions like this remind me how grateful I am to have J in my toolbox.
I have a 6,000 row excel file with 75 columns that I needed to 'unpivot'
I could have used the Excel Power Query's Unpivot function, but without
that or J it would have been a hassle.
On Thu, Mar 17, 2016 at 10:54 PM, Henry
Henry, Your result has 24 rows.
Linda
-Original Message-
From: Programming [mailto:[email protected]] On Behalf
Of Henry Rich
Sent: Thursday, March 17, 2016 10:55 PM
To: Programming forum
Subject: Re: [Jprogramming] transform table columns to rows
Your table is
Is there a simple or efficient transform of
tbl =: ' ' cut every LF cut (0 : 0)
id col1 col2 col3 col4 col5 col6
1 ab cd ef gh hi jk
2 lm no pq rs tu vw
3 xy zz aa bb cc dd
)
+--+++++++
|id|col1|col2|col3|col4|col5|col6|
+--+++++++
|1 |ab |cd |ef
11 matches
Mail list logo
