cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Mickyboy
Level V

Script for Stack

Hi Guys,

 

Have written two bit of code to stack a Dt this:

Stack(

 

columns(

:Name( "L1-D1-O1-R1" ),

:Name( "L1-D1-O1-R2" ),

:Name( "L1-D1-O1-R3" ),

:Name( "L1-D1-O2-R1" ),

:Name( "L1-D1-O2-R2" ),

:Name( "L1-D1-O2-R3" ),

:Name( "L1-D2-O1-R1" ),

:Name( "L1-D2-O1-R2" ),

:Name( "L1-D2-O1-R3" ),

:Name( "L1-D2-O2-R1" ),

:Name( "L1-D2-O2-R2" ),

:Name( "L1-D2-O2-R3" ),

:Name( "L2-D3-O1-R1" ),

:Name( "L2-D3-O1-R2" ),

:Name( "L2-D3-O1-R3" ),

:Name( "L2-D3-O2-R1" ),

:Name( "L2-D3-O2-R2" ),

:Name( "L2-D3-O2-R3" ),

:Name( "L2-D4-O1-R1" ),

:Name( "L2-D4-O1-R2" ),

:Name( "L2-D4-O1-R3" ),

:Name( "L2-D4-O2-R1" ),

:Name( "L2-D4-O2-R2" ),

:Name( "L2-D4-O2-R3" )

 

),

And this:

dt2 = dta << stack(column(column("L1-D1-O1-R1"), column("L1-D1-O1-R2"), column("L1-D1-O1-R3"), column("L1-D1-O2-R1"), column("L1-D1-O2-R2"), column("L1-D1-O2-R3"),column("L1-D2-O1-R1"),column("L1-D2-O1-R2"), column("L1-D2-O1-R3"), column("L1-D2-O2-R1"), column("L1-D2-O2-R2"), column("L1-D2-O2-R3"), ///

column("L2-D3-O1-R1"), column("L2-D3-O1-R2"), column("L2-D3-O1-R3"), column("L2-D3-O2-R1"), column("L2-D3-O2-R2"), column("L2-D3-O2-R3"),column("L2-D4-O1-R1"), column("L2-D4-O1-R2"), column("L2-D4-O1-R3"), column("L2-D4-O2-R1"),column("L2-D4-O2-R2", column("L2-D4-O2-R3")),

Source Label Column( "Op_Rep" ),

Stacked Data Column( "titer" ))

 

);

Cant get either of them to work, any ideas????

 

 

Thanks Mick

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson
Super User

Re: Script for Stack

What errors are you seeing in the JMP Log when you run these? Without seeing that, along with not knowing what the input data table looks like, it is tough to see the problem. I suggest that you run the stack interactively, and then look into the data table produced, and Edit the "Source" for the new data table, and it will give you the JSL to use
Jim

View solution in original post

Mickyboy
Level V

Re: Script for Stack

Hi txnelson,

 

Once again thanks for your reply, after i posted this l went home for the weekend came in this morining and first thing re ran the script and it worked, the second part of the script, so again thanks for the reply

 

 

Rgs Mick

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Script for Stack

What errors are you seeing in the JMP Log when you run these? Without seeing that, along with not knowing what the input data table looks like, it is tough to see the problem. I suggest that you run the stack interactively, and then look into the data table produced, and Edit the "Source" for the new data table, and it will give you the JSL to use
Jim
Mickyboy
Level V

Re: Script for Stack

Hi txnelson,

 

Once again thanks for your reply, after i posted this l went home for the weekend came in this morining and first thing re ran the script and it worked, the second part of the script, so again thanks for the reply

 

 

Rgs Mick