Welcome to the JMP User Community!

Latest Discussions

• split plot unbalanced number of replicates

  hello,I'm working on a large breeding experiment testing the effect of drought on different genotypes. We set the main plot to irrigation level ( 2 levels), and the sub plot is the genotype ( 300 genotypes), 280 of them replicate in all three blocks and 20 are only found in two of the block. is there a way to estimate main effect of this kind of experimental design on JMP? thanks, Roy    

  RoySadeh

  Discussions |

  Jun 27, 2022 10:41 AM

  1380 views | 2 replies

• Open XLS table that contains cell formula's

  Hi, I have an excel sheet which contains cells with values, strings, and formula's.  JMP imports the cells with values, strings, and simple formula's correctly.  However, if the cell has a complicated formula (=SUBSTITUTE(MID(FORMULATEXT(Z29), 2, LEN(FORMULATEXT(Z29))-1),MID(FORMULATEXT(Z29),9,3),"x")) JMP replaces that cell with "#NAME?".  It appears to not understand part of the formula, even th...

  Niklotus

  Discussions |

  Jun 24, 2022 7:54 AM

  2116 views | 4 replies

• Open() , save and close while script is running

  Hi, Is there a way I could open the data table, save in the variable and close it while the script is running? It's annoying sometimes because the input data table will pop up. I tried using close window, close() but they didn't seem to work.Names Default To Here( 1 ); Clear Globals(); Clear Log(); dt2 = Current Data Table(); nw = New Window( "New window", <<modal(), Text Box( "Tests", ...

  Jackie_

  Discussions |

  Jun 22, 2022 10:36 PM

  1848 views | 4 replies

• How do I run multiple CMD commands?

  Hello, I am trying to do a simple extract of a zip file (TGZ) from JMP using the command prompt, and I don't manage to do it using the following approach (I tried many ridiculous ideas, none seem to work...):  Names Default To Here( 1 ); path1="C:/Users/niros/Downloads/"; path2="C:/Program Files/WinRAR/WinRAR.exe"; path3="C:/Users/niros/Downloads/LP.tgz"; RP = RunProgram( Executable( "CMD.EXE" ...

  Niros

  Discussions |

  Jun 22, 2022 7:07 AM

  3492 views | 5 replies

• Error: Unexpected end of input. Perhaps there is a missing "," or ")".

  Hello, Whilst trying to automate data visualisation from a file I am encountering an error message after entering these lines of code // Delete selected rows dt( "Export" ) << select where(row() >= N Rows(dt) - 1; dt << delete rows; Here I would like to delete the last 2 rows of each file I open regardless of their length.If you could help, that would be very much appreciated :)  Names Default To ...

  jlmbs

  Discussions |

  Jun 22, 2022 7:02 AM

  3162 views | 2 replies