78811_en-US

liliconcom

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

 

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

Re: Script for StackWhat 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