Welcome to the JMP User Community!

Latest Discussions

• Equivalent to an Index(Match()) in Excel

  I have some data that I would like to calculate the % Error between the first and all subsequent measurements for each unique ID. I haven't been able to figure out how to get data from one cell based on values from other rows-columns. Does this require JSL, or if I can just create a formula as I've done in Excel.I'd like the 2 columns that I've highlighted to be calculated using a formula, but wit...

  JasonWS

  Discussions |

  Jan 5, 2025 9:33 AM

  3652 views | 7 replies

• moving a few columns/rows from table a to b

  Clear Symbols(); // Open a file dialog to choose the text file txtFilePath = Pick File("Choose a text file", {"Text Files|*.txt"}); // Check if a file was selected If(txtFilePath != "", // Convert the file path to ensure it's in the correct format txtFilePath = Convert File Path(txtFilePath); // Import the text file into a new JMP table dt1 = Open( txtFilePath, Delimiter("\t") ...

  RepeatedCoyote3

  Discussions |

  Jan 5, 2025 12:18 AM

  633 views | 2 replies

• Find the Highest "F ratio" by fit stepwise

  Hello there,
  I need help with find the highest "F ratio" by fit stepwise. For example I have two groups- {A,B,C} and {1,2,3}
  I put the first group ({A,B,C}) in Y and put the second group ({1,2,3}) in "Construct model Effects".
  I want JMP will give the best pair between each group based on "F ratio"
  for example A-2, B-1, C-3
  
  How can I do it quickly and easily? It give me a lot of tabl

  Liranlev

  Discussions |

  Jan 4, 2025 11:07 PM

  929 views | 2 replies

• Expression Indexing: How to climb the Expression Tree?

  This post was born as a wishlist entry - but it turns out that the wish is already partially possible (see @jthi's answer below).
  So I moved it here to make the results more visible.
  
  The original wish - which asks for a functionality which goes beyond what is already possible - can be found here:
  Expression Indexing: read and write access Please have a look and decide if it could help you as well ......

  hogi

  Discussions |

  Jan 4, 2025 12:03 AM

  1589 views | 2 replies

• Script to Edit a Script

  I have a script that takes a standard contour plot output and rearranges the plots into columns. Goes from to The placement of the text boxes is causing the script to misfire. Is there a different way to get the result?  If not, can I adjust the present script somehow to sort it?  I was wondering if the parent script could execute a find/replace on the child script to perform some adjustments? cle...

  SpannerHead

  Discussions |

  Jan 3, 2025 10:32 PM

  1603 views | 7 replies