cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Open XLS table that contains cell formula's

    Hi, I have an excel sheet which contains cells with values, strings, and formula's.  JMP imports the cells with values, strings, and simple formula's correctly.  However, if the cell has a complicated formula (=SUBSTITUTE(MID(FORMULATEXT(Z29), 2, LEN(FORMULATEXT(Z29))-1),MID(FORMULATEXT(Z29),9,3),"x")) JMP replaces that cell with "#NAME?".  It appears to not understand part of the formula, even th...

    Niklotus Niklotus
    Discussions |
    Jun 24, 2022 7:54 AM
    1235 views | 4 replies

  • How do add text to a cell that has an image loaded?

    Is it possible to add text to a cell that has already loaded images? Thanks!

    lwx228 lwx228
    Discussions |
    Jun 24, 2022 6:49 AM
    3372 views | 12 replies

  • How do I wait until a button is pressed in a function of another file to return to the main file?

    I'm having an issue in my code where I press a button and it goes into another function in another file (using Include("filename.jsl"); Once the button is pressed the function from the other file runs and returns back to the main function in the main file and continues running. This is not what I want. How can I make it so the code stops in the second function (the one in another file) and wait fo...

    Andyon98 Andyon98
    Discussions |
    Jun 24, 2022 5:57 AM
    1449 views | 4 replies

  • How to make formula columns stand out

    I am trying to update and understand a very large old data set, some of the data comes from other workbooks and some of it is calculated from multiple columns. I would like a way to highlight or otherwise identify columns that are derivatives of other columns vs ones where the data is entered. Is there anyway to do this in JMP? Would also be nice to make some columns into a block. In excel I would...

    MostlyHarmless MostlyHarmless
    Discussions |
    Jun 24, 2022 12:09 AM
    871 views | 2 replies

  • Enter the file name and save

    Hi, I am trying to create a jsl script where the user can type the file name and save as csv. Here's what I tried. Save() doesn't work when I enter the variable exE. Any suggestions?dt = Current Data Table(); current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) ); Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) ); exC = ".cvs"; Nw = ne...

    Jackie_ Jackie_
    Discussions |
    Jun 23, 2022 8:45 PM
    981 views | 1 replies

Latest Discussions

  • How do I wait until a button is pressed in a function of another file to return to the main file?

    I'm having an issue in my code where I press a button and it goes into another function in another file (using Include("filename.jsl"); Once the button is pressed the function from the other file runs and returns back to the main function in the main file and continues running. This is not what I want. How can I make it so the code stops in the second function (the one in another file) and wait fo...

    Andyon98 Andyon98
    Discussions |
    Jun 24, 2022 5:57 AM
    1449 views | 4 replies

  • How to make formula columns stand out

    I am trying to update and understand a very large old data set, some of the data comes from other workbooks and some of it is calculated from multiple columns. I would like a way to highlight or otherwise identify columns that are derivatives of other columns vs ones where the data is entered. Is there anyway to do this in JMP? Would also be nice to make some columns into a block. In excel I would...

    MostlyHarmless MostlyHarmless
    Discussions |
    Jun 24, 2022 12:09 AM
    871 views | 2 replies

  • Enter the file name and save

    Hi, I am trying to create a jsl script where the user can type the file name and save as csv. Here's what I tried. Save() doesn't work when I enter the variable exE. Any suggestions?dt = Current Data Table(); current_pref = Char( Arg( Parse( (Char( Get Preferences( Export settings ) )) ), 1 ) ); Pref( Export Settings( End Of Field( Comma ), Export Table Headers( 1 ) ) ); exC = ".cvs"; Nw = ne...

    Jackie_ Jackie_
    Discussions |
    Jun 23, 2022 8:45 PM
    981 views | 1 replies

  • Questions on RSM

    Hello everyone, I have some questions on RSM:  I finished my experiments and I want to generate the Response Surfaces now. For example, one looks like this:  Q1: I would like to add this graph to a word document, how can I do that? Everytime I do this, the resolution of the axis are very bad and even increasing the font size does not help. Is the only valid method to use the snipped tool?  Q2: Whe...

    Artaxerxes90 Artaxerxes90
    Discussions |
    Jun 23, 2022 1:48 PM
    1270 views | 3 replies

  • Exclude data in formula

    I found that when a row is Hide and Excluded, the data is still being used by a formula in another column.Here is an example, Column2 formula is Col Maxium (:Coumn 1), row 4 is excluded and hidden, but the data is still being used by the formula in Column 2.  How to exclude data from row 4 so that it is not used by the formula in Column 2?   

    GroupSquareWolf GroupSquareWolf
    Discussions |
    Jun 23, 2022 12:08 PM
    2411 views | 4 replies

Latest Discussions

  • Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

    Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...

    MomentMonster90 MomentMonster90
    Discussions |
    Jun 13, 2022 5:53 AM
    618 views | 0 replies

  • Validate column values (make sure all values in column follow a specific pattern)

    Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?  

    miguello miguello
    Discussions |
    May 6, 2022 11:09 AM
    484 views | 0 replies

  • SUR (Seemingly Unrelated Regressions)

    HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
    and it is in stat in the nlsur command Regards

    Raaed Raaed
    Discussions |
    May 5, 2022 4:45 PM
    625 views | 0 replies

  • Friedman post hoc analysis

    Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.  

    pnakashe pnakashe
    Discussions |
    May 5, 2022 12:02 PM
    781 views | 0 replies

  • JMP script: Script Alarm Control chart- Table with atypical batch number and values

    Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script:  z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...

    Sebastienlg Sebastienlg
    Discussions |
    Apr 29, 2022 6:29 AM
    554 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

JMP® Marketplace Feature: S3 Data Connector

 view all blog articles

Learn more about JMP's premier analytics conference