topic Re: Script for Stack in Discussions

Script for Stack

Mickyboy — Fri, 12 Oct 2018 05:38:50 GMT

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

txnelson — Fri, 12 Oct 2018 05:48:13 GMT

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

Re: Script for Stack

Mickyboy — Sun, 14 Oct 2018 22:10:54 GMT

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