Welcome to the JMP User Community!

Latest Discussions

• Load Factors table into DOE using JSL

  I am designing multiple DOE using risks assesments done in Excel. I wrote a script to organize all the variables into a neat table and converted the properties to that of a factors table (credit to a previous post (Saving a data table as a factors table:(dt3 = Current Data Table(); nomdata = dt3 << get column names( nominal ); condata = dt3 << get column names( continuous ); For( i = 1, i <= N I...

  nguyendv0610

  Discussions |

  Jul 1, 2019 2:12 PM

  3087 views | 1 replies

• Accelerated Reagent Stability Studies

  Hi All,I'm exploring JMP Platform options for analyzing accelerate reagent stability studies.  A typicall study would consist of the following. Store reagents at 4 or 5 different temperatures (e.g. 15 degC, 20 degC, 30 degC, 35 degC, 40 degC). The "activity" of of reagent (Concentration of a molecule, activity of an enzyme, etc.) would then be measured at 4-5 time points (e.g. 1 day, 4 days, 7 day...

  DennisB

  Discussions |

  Jul 1, 2019 9:48 AM

  4711 views | 3 replies

• Exporting Select Columns to CSV Filtered by Formula Column

  Hey everyone,  I'm new to JMP scripts and I'm hoping this may help others too.  From the sample data screenshot below (stored as a .JMP file), I'd like to select Material and Month and round Stock to a whole number.  I'd then like to filter only records where the rounded Stock calculation is greater than zero.  Finally I'd like the results to be saved as a CSV file.    Here is my initial attempt a...

  William_S

  Discussions |

  Jul 1, 2019 9:34 AM

  4047 views | 2 replies

• Set focus on text edit box

  HelloI try to check for an entry in a database with a barcode scanner.It will enter the number and gives an enter at the end whitch triggers the script of the "text edit box".What doesn't work is to reset the focus back on the box to enter the next number.Names Default To Here( 1 ); dt = current data table(); try(win1<<close window;); my_expr=expr( print(pnr << get text()); pnr << settext("")...

  Mauro_Gerber

  Discussions |

  Jul 1, 2019 2:49 AM

  5830 views | 5 replies

• New Sequence column creation based on another ID columns

  I've an existing column which has the Customer ID which occurs multiple times in the whole data table on a different date/time. I want to create a sequence such as 1,2,3 for each of the Unique Customer ID based on the date/time variable. How to acheive the same in JMP ?  Sample Data snippet (Customer ID | Date)ABC | 1-JUN-2019 XYZ | 1-JUN-2019ABC | 3-JUN-2019ABC | 4-JUN-2019XYZ | 7-JUN-2019 I want...

  venkateshc78

  Discussions |

  Jun 30, 2019 1:56 PM

  2660 views | 2 replies