cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • Open Files in Directory based on a List of Variable Filenames

    Hi all, I have a list of filename. This list of filename is variable and change from to time. I want to match these file name to the files available in a directory. If match , open the files. I write below code and run it. It does not work.Need guidance here.  folder = "C:\savefile\"; filename ={"Jan", "Feb", "Mar"}; filelist= Files In Directory(folder); For(i=1, i<= N items(filename), i++, ...

    bzanos bzanos
    Discussions |
    Oct 9, 2021 6:29 PM
    2485 views | 4 replies
  • Stepwise Show Formula Change

    Hello I am fairly new to JMP, I created a stepwise and saved my probability formula. It shows my formula answers for Lin(no), Prob(no), and Prob(yes), is there any way to get it to show me Lin(yes). I need it to actually show up on the data sheet aswell.

    mbauriem mbauriem
    Discussions |
    Oct 9, 2021 10:50 AM
    897 views | 1 replies
  • Screening designs - How do we know if the effects are not significant or if the whole data is not good (significant variation) without doing replicates?

    To show robustness of a chemical process, we often need to show regulators that selected parameters (temp, equivalents, time and reagent ratios) are not impacting the quality (purity) of final product.  In order to show this, regulators prefer performing screening designs.  Usually, we want to show that the parameters do not have detrimental effect within the ranges studied, so that the process is...

    jmpkat jmpkat
    Discussions |
    Oct 9, 2021 10:44 AM
    4762 views | 10 replies
  • Value Ordering in JMP Script by a Variable

    Hello all,In my data set I will be using a column, called Set, as my x-axis variable in a barchart.  I want them to be sorted in the order from smallest response value to largest response value so I have bars that are increasing in length.  For example if I have the following data:Set      ResponseA          5B          -7C          10I would want the order in the barchart to be B, A, C.  Obviousl...

    mjbauer mjbauer
    Discussions |
    Oct 9, 2021 6:57 AM
    20161 views | 7 replies
  • Saving Variables to New Tables and New Columns

    I wrote a script that finds rows where col2 and col3 match specific strings and then returns the value of the cell in col7 of those rows.  However, I am having problems writing these variables to New Columns in New Tables. .... New Table( "Results",Add Rows( 2 ), New Column( " FUS",Character,"Nominal", Set Values({"Fus1","Fus2"})), New Column( "PASS/FAIL",continuous,"Nominal", formul...

    SMW SMW
    Discussions |
    Oct 8, 2021 4:21 PM
    2155 views | 5 replies

Latest Discussions

  • Stepwise Show Formula Change

    Hello I am fairly new to JMP, I created a stepwise and saved my probability formula. It shows my formula answers for Lin(no), Prob(no), and Prob(yes), is there any way to get it to show me Lin(yes). I need it to actually show up on the data sheet aswell.

    mbauriem mbauriem
    Discussions |
    Oct 9, 2021 10:50 AM
    897 views | 1 replies
  • Screening designs - How do we know if the effects are not significant or if the whole data is not good (significant variation) without doing replicates?

    To show robustness of a chemical process, we often need to show regulators that selected parameters (temp, equivalents, time and reagent ratios) are not impacting the quality (purity) of final product.  In order to show this, regulators prefer performing screening designs.  Usually, we want to show that the parameters do not have detrimental effect within the ranges studied, so that the process is...

    jmpkat jmpkat
    Discussions |
    Oct 9, 2021 10:44 AM
    4762 views | 10 replies
  • Combining models

    If I learned one thing from Discovery Summit Americas this year, it was how common it is to average and/or create ensemble models, something I had heard about but never considered (being a modeling novice). So I decided to do it. Making an ensemble model is easy; I saved the model as a prediction formula and simply included that as a predictor in the next round of model screening (using JMP Pro 16...

    abmayfield abmayfield
    Discussions |
    Oct 8, 2021 9:56 AM
    1960 views | 3 replies
  • Import Excel with Macro formula

    I have an issue here: When importing an Excel file which contains Macro based formulas, these cells only yield missing values instead of their actual values. How can I import this data correctly? Note: I assume that the values are stored in the Excel file, similar to the values of normal formula cells, because when I open the file in Excel with deactivated macros, the values are well present. Here...

    JWi JWi
    Discussions |
    Oct 8, 2021 4:53 AM
    6950 views | 9 replies
  • Column filter for graph builder (Parallel plot)

    The local data filter allows the user to select the rows of interest. I wonder how I can allow the same functionality but for columns without having to edit the graph. For example, allowing the user to select what to visualize between weight, size, age, sex...  Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Graph Builder( Size( 490, 448 ), Show Control Panel( 0 ), Varia...

    FN FN
    Discussions |
    Oct 8, 2021 1:15 AM
    883 views | 1 replies

Latest Discussions

  • JSL: Saving multiple chart and auto fit each of them into 1 page

    I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...

    giin giin
    Discussions |
    Oct 7, 2021 6:42 AM
    800 views | 0 replies
  • Skip Lot Sampling Plan

    Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam

    AT AT
    Discussions |
    Sep 10, 2021 10:38 AM
    946 views | 0 replies
  • Time values in xls or xlsx, csv, and JMP

    Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...

    fliew0410 fliew0410
    Discussions |
    Sep 7, 2021 7:25 AM
    945 views | 0 replies
  • Error while using Azure MFA to connect with JMP

    I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14.  [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.

    hariharan249 hariharan249
    Discussions |
    Sep 3, 2021 7:14 AM
    660 views | 0 replies
  • Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

    Hi everyone,  I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along.  I f...

    caseylott caseylott
    Discussions |
    Aug 17, 2021 11:15 AM
    1216 views | 0 replies
view all discussions