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

  • Combine Date Column and Time Column to "DateTime"

    Hi, I imported data from the .xls file. There is a "Date" column and "Time" column. I have to create a new column with Date Time Combine.I used below formula Date MDY( Month( :Date ), Day( :Date ), Year( :Date ) ) + (Hour( :Time ) * 3600 + Minute( :Time ) * 60 + Second( :Time )) Some rows the output is off by roughly 1 minute but some rows are correct.  How Can I fixed this?

    yanee yanee
    Discussions |
    Feb 15, 2024 9:42 PM
    1349 views | 3 replies

  • Getting the items of a character column as a list

    Hi all, I'm simply trying to get a character column as a list. The column has duplicate entries and I would like a function that returns only the unduplicated rows. I tried using the "Get as matrix" function along with the " as column" function, but I kept getting different errors.  Any help is appreciated. Thanks.

    RA899 RA899
    Discussions |
    Feb 15, 2024 9:36 PM
    1113 views | 2 replies

  • Visualizing 2-way clustering

    Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...

    ehchandlerjr ehchandlerjr
    Discussions |
    Feb 15, 2024 2:53 PM
    429 views | 0 replies

  • A question related to generating a plot using JMP

    Wonder if anyone know how to plot using JMP to get a plot similar to what I generated using excel.  The JMP table is attached.

    JMP2021 JMP2021
    Discussions |
    Feb 15, 2024 11:48 AM
    1127 views | 3 replies

  • Data Table Box with local data filter

    Bug, or user error?If I create a Data Table Box using the following code:Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); nw = New Window( "Demo Data Table Box", Data Filter Context Box( H List Box( dt << Data Filter( //Show Controls( 0 ), Local, //Add Filter( columns( :sex ) ) ), dtb = data Table Box( dt ) ) ) );then manually select 'sex' as the f...

    matth1 matth1
    Discussions |
    Feb 15, 2024 11:25 AM
    1148 views | 2 replies

Latest Discussions

  • Combine Date Column and Time Column to "DateTime"

    Hi, I imported data from the .xls file. There is a "Date" column and "Time" column. I have to create a new column with Date Time Combine.I used below formula Date MDY( Month( :Date ), Day( :Date ), Year( :Date ) ) + (Hour( :Time ) * 3600 + Minute( :Time ) * 60 + Second( :Time )) Some rows the output is off by roughly 1 minute but some rows are correct.  How Can I fixed this?

    yanee yanee
    Discussions |
    Feb 15, 2024 9:42 PM
    1349 views | 3 replies

  • Visualizing 2-way clustering

    Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...

    ehchandlerjr ehchandlerjr
    Discussions |
    Feb 15, 2024 2:53 PM
    429 views | 0 replies

  • Script for multiple data tables/ Workflow

    Hi everyone,  I am relatively new to JMP and especially to scripting in JSL. I am looking for a way to apply a existing script to all currently open data tables (imported via multiple files import). Even though I researched through the abundance of community threads about this topic, I was not able to piece together a working solution. Okay, so I have the following working JSL code (note: embedded...

    Gab_K Gab_K
    Discussions |
    Feb 15, 2024 7:30 AM
    712 views | 1 replies

  • Save data as Excel file and immediately open it on the computer

    HelloI would like to save data in an Excel file and open itI have written the command at the end of the scriptI see JMP saved the data as well, but don't open the file in Excelwhat I have missed in JSL? dt_excel = dt_p << Save( "C:\Users\dburmist\Downloads\Bucket.xlsx" );
    dt_excel = dt_p << open( "C:\Users\dburmist\Downloads\Bucket.xlsx" );

    Dennisbur Dennisbur
    Discussions |
    Feb 15, 2024 7:23 AM
    735 views | 2 replies

  • Predictor Screening Question

    Just a general question - for the Predictor Screening Platform, if you're trying to find variables related to a particular Response Output (say product Yield) - would you ever bring in another response variable & add it to the "X" box - like "impurity" or something along those lines? Or should you only be bringing in explanatory variables in that "X" box? 

    mjz5448 mjz5448
    Discussions |
    Feb 15, 2024 12:23 AM
    782 views | 1 replies

Latest Discussions

  • Visualizing 2-way clustering

    Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...

    ehchandlerjr ehchandlerjr
    Discussions |
    Feb 15, 2024 2:53 PM
    429 views | 0 replies

  • Help with JMP formula (IFERROR)

    My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success. 

    UpliftElk866 UpliftElk866
    Discussions |
    Feb 13, 2024 12:19 PM
    458 views | 0 replies

  • Scheduled job failed

    Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?

    shaiv90 shaiv90
    Discussions |
    Feb 11, 2024 11:09 PM
    504 views | 0 replies

  • PickFile(), Projects and Network Drives

    Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory"; Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...

    hogi hogi
    Discussions |
    Feb 9, 2024 3:07 PM
    512 views | 0 replies

  • How might I include a line break (or a second line) in the print header of a PDF generated from a Journal window?

     w = New Window("window", <<Journal, hlb = hlistbox() ); w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" ); w << SavePDF ( "C:\Users\blahblah.pdf");The above script should include a line break in the "left header" so that it has two lines. Instead the resulting PDF just has a non-printing box character between the two words, like this ... and if i copy that text into this wi...

    mann mann
    Discussions |
    Jan 31, 2024 6:25 AM
    664 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