Welcome to the JMP User Community!

Latest Discussions

• Calculating percent of initial concentration on experiments with different Reagents on different Days

  Hi, I am using JMP 16.  I have the following Table   The first column has reagent concentrations at time T =0, T = 2 h, T = 6 h, T = 24 h, and T = 48 h. These experiments are done on different dates with different brands of reagents.  For every unique date and reagent brand I would like calculate the percentage of reagent  left at after T = 2 h, T = 6 h,, T = 24 h, and  T = 48 h.  I could do it ma...

  timothy_forsyth

  Discussions |

  Feb 20, 2025 9:25 PM

  1084 views | 3 replies

• Database Trawler Crashing

  I wrote a script to trawl through available databases to see if a particular lot ID shows up and pull the data.  My approach involves opening a series of files and then closing the empty ones, open to suggestions on how not to need that?  I have one particularly populous database that opens >1000 files and the script appears to crash when attempting to close the empty data tables.  Names Default T...

  SpannerHead

  Discussions |

  Feb 20, 2025 1:39 PM

  1393 views | 8 replies

• How do I assign a SQL query result to a variable?

  Hello! I am new to JMP/JSL scripting and am having some trouble figuring things out. I feel like what I am trying to do should be very simple but nothing seems to be working as I would expect and google is failing me.  What I am trying to do: I have a simple stored procedure that just returns a control limit value from our SQL database based on a few parameters I pass to it. I am then trying to as...

  JaneCuthbertson

  Discussions |

  Feb 20, 2025 10:11 AM

  1481 views | 4 replies

• How to exclude headers and footers while importing multiple txt files via Import Multiple Files Wizard?

  I am trying to import multiple *.txt data files from folders and subfolders. All data files have headers and footers (both starting with !). Headers are from line 1 to line 21. Line 22 has the test parameter names while test data starts from line 23. When data ends, the footer information starts (with !). All data is tab separated. 1. I am unable to get data imported with parameter names as column...

  Neo

  Discussions |

  Feb 20, 2025 10:07 AM

  918 views | 4 replies

• Setting Default Selected Item in a Combo Box

  When using a combo box, how can I set it to display the currently selected item by default? For example, if the default is the first item, which is "1", what should I do to have the combo box show "7" as the currently selected item by default, as shown in the image below? a = {"1", "2", "3", "4", "5", "6", "7", "8", "9", "0"}; New Window( "Test", testCB = Combo Box( a, ) );  

  BabyDoragon

  Discussions |

  Feb 20, 2025 4:31 AM

  541 views | 2 replies