Script for Stack

[#1]

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 solution]

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

[#3 · Accepted solution]

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