Welcome to the JMP User Community!

Latest Discussions

• How to keep all charaters before a period?

  Hi all, This is a simple question I am sure...but I have a column filled with file names "xfsfds.csv" and "sdfdgdfg.csv" What if I want to just keep the names in the column, and get rid of all the ".csv" at the end? Thanks!

  schou1994

  Discussions |

  Feb 8, 2021 4:33 PM

  1078 views | 1 replies

• Display box that can both input column name and numeric value

  Is there a display box that can take both column name and numeric value ? I'm trying to create a window where users can either select a column from column list (like a col list box) or insert a constant value (like a number edit box).

  Djtjhin

  Discussions |

  Feb 8, 2021 8:25 AM

  2139 views | 6 replies

• Genetic Algorithms, Simulated Annealing, etc. for Optimizing QSAR Regression Equations

  I am interested in creating regression equations for QSAR-related problems.  The general idea is to find a linear regression equation from a pool of many (>200) independent variables or descriptors to predict one dependent variable.  Typically, the number of rows/observations is small (n=50 at a minimum). There are ways to do this using Generalized Regression in JMP.  While the penalized regressio...

  PrakashMadhav

  Discussions |

  Feb 8, 2021 8:19 AM

  2714 views | 5 replies

• Mixture design question

  Hello everybody, I would like to know if it is possible to use a Mixture design if we want to study the impact of the proportion of the mixture factors but also the total quantity of the mixture.Basically I would have two mixture factors (corresponding to the proportion of my 2 components ) and a continuous factor to represent the total quantity of the mixture (e.g. from 100ml to 500ml). Is it pos...

  anne_sa

  Discussions |

  Feb 8, 2021 8:10 AM

  2862 views | 6 replies

• How do I create a JMP script to import multiple Excel workbooks from SharePoint?

  Hi Everyone, I have several Excel o365 workbooks stored in SharePoint that I need to load to JMP and rename each table based on the filename of the excel workbook.  I found code snippets from the JMP Community to help me, thank you everyone!! The script: hard codes the file names and SharePoint pathsopens the SharePoint sitelocates the excel fileopens/imports the Excel file However there are 2 iss...

  Onjai

  Discussions |

  Feb 8, 2021 6:58 AM

  3975 views | 2 replies