Welcome to the JMP User Community!

Latest Discussions

• Full Outer Join- Timestamp not matching- adding more rows

   I need to match 6 files with data collected at different time stamps from different devices (all with 1 minute resolution in 2021).  (Note: I need a physically "joined" file  for a different purpose, So, not doing Virtual Join)I tried full outer join (including non-matches from "main table" and "with table"; Did not include "drop multiples" for either of the tables.But it kept adding more rows ev...

  SymS

  Discussions |

  Jan 20, 2022 2:13 PM

  3122 views | 9 replies

• Obtaining acceptance criteria limits for potency assay

  Hi, We are trying to set acceptance criteria limits for a potency assay. Most of the data are EC50, relative potency values and ratios. We have so far used the control charts with the moving range (MR) as limits or with levey jennings (LJ). However, the LJ limits which JMP calculates are often too wide and the MR ranges often seem unsuitable (limits widening after removal of an outlier).  I am new...

  sarahg

  Discussions |

  Jan 20, 2022 7:38 AM

  3330 views | 6 replies

• Data Table evaluation in For Loop from a list

  I keep running into an error with my script to rename data tables using a For loop.
  
  Here's a simplified version of my script
  
  OldNames = {"Old Name 1", "Old Name 2", "Old Name 3"}; NewNames = {"New Name 1", "New Name 2", "New Name 3"}; For( i, i <= NNames, i++, dt = Data Table( OldNames[i] ); dt << Set Name( NewNames[i] ); );
  I keep getting the following error
  
  Cannot locate data table in acc...

  user8421

  Discussions |

  Jan 19, 2022 8:00 PM

  3623 views | 5 replies

• Prompt for a column/field

  Hello everyone, I am looking to see a prompt to select or ask the user to enter the text or product etc, and pull the query only related to that data Is that possible? If yes, then how? Please guide me.  Thanks in advance 

  penalah

  Discussions |

  Jan 19, 2022 11:30 AM

  862 views | 1 replies

• Multi-variable interpolation (modeling?)

  Suppose I have a big table of simulation output with 5 input variables (i1, i2, i3, i4, i5) and 2 output variables (o1, o2). Now suppose I have a pair of output numbers, e.g. (5,17) and I want to find pretty good values for i1 thru i5, such that if I put them back into the simulation, I'd get something close to (5,17) as output. Does JMP do anything like this?

  BHarris

  Discussions |

  Jan 19, 2022 10:19 AM

  3415 views | 7 replies