Welcome to the JMP User Community!

Latest Discussions

• How to prompt a " File in Use" message

  Hi,   I'm currently creating a JMP file which acts as a database. Therefore I would like to prompt a "File in use" message and keep the file locked for editing when someone else already opened the database and is making changes to the file. For example, the same message you get when you open an Excel file on a server location that is already in use by someone else:           I think I already fou...

  RobRobeyns

  Discussions |

  Apr 24, 2024 12:54 PM

  5734 views | 10 replies

• DoE and inputting replicate analytics

  Hi, I have performed a DoE as designed, but would like to know how to evaluate replicate analytical data which feeds into the response for each condition. We usually use analytical data provided by our analytical department, but are investigating a rapid analysis tool for future applications. While this tool is helpful, it appears most accurate when performing replicate analysis, and then averagin...

  MetaLizard62080

  Discussions |

  Apr 24, 2024 8:58 AM

  2780 views | 6 replies

• How to Code a new column by referencing text in second column?

  How would I code a new column to fill each cell with a specific text based on the text in a second column? I have a "well" column with A1-A100. I need to create a second column with Treatment "A", for wells A1-A10, "B" for wells A11-A20, etc.Thanks! 

  Mcc99

  Discussions |

  Apr 24, 2024 8:21 AM

  1292 views | 3 replies

• Subset rows automatically selected for by key word in column?

  I have a tall data table with sample ID, test, count, and some categorical info. The test column identifies which test the count refers to and whether it's a positive or negative population. For example "Test one positive", "test one negative", etc., as well as some rows such as "total tests". These repeat for each sample.How would I select all the rows with a "positive" in the column regardless o...

  Mcc99

  Discussions |

  Apr 24, 2024 7:41 AM

  1154 views | 1 replies

• Optimizing list box content update.

  Hello JMP community, Lately, I was looking into improve the performance of my internal JSL scripts and I found the following performance issues that I would like to address.Lets take the following script (JMP 17.2 PRO running on macOS): Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); values = Column( dt, 1 )[dt << get rows where( Excluded( Row State() ) != 1 )]; new window(...

  JmpNoobScripter

  Discussions |

  Apr 24, 2024 7:16 AM

  2791 views | 5 replies