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: 
  • 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
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

  • JSL for importing spec limits

    I am writing a JSL code to import specification limits from a separate data table into the main data table.  // Open the Spec Limits table specTable = Open("C:\Trending Tool Spec Limits.jmp"); // Open data table for analysis dataTable = Data Table( "Trending data" ); // Extract Spec Limits and Show Limits from Spec Table For Each Row( specName = specTable:Variable[]; LSL = specTable:LSL[...

    Steffen_Bugge Steffen_Bugge
    Discussions |
    Aug 22, 2024 11:49 PM
    2306 views | 7 replies

  • Interval, different in JMP, LOGICALLY SHOULD BE SAME.

    Hi.I faced a problem and appologize in advance that it might be a foolish question.make simple, the situation is, Data ist={0,3,6,9,12}y1={y11,y12,y13,y14,y15}y2={y21,y22,y23,y24,y25}y3={y31,....}where y1,y2,y3 are the Batch number (Lot number)So, there should be 3 respective regression line. I tested the line comparability and the conclusion was "Different Slope and Different Intercept" Thus, I p...

    MikeKim MikeKim
    Discussions |
    Aug 22, 2024 10:54 PM
    3379 views | 10 replies

  • select all the excluded cols, then delete?

    I'm working with a script that's doing some big data analysis on dt's with 10k+ cols. some of my first passes for screening these features results in excluding ~90% of the cols for further deeper analysis. In the interest of tidying up and reducing the dt, I want to select all the excluded cols and delete them. Any tips on how to script this? In my script, I am generating a colsList that is the 'k...

    TriangularLlama TriangularLlama
    Discussions |
    Aug 22, 2024 5:26 PM
    848 views | 1 replies

  • JMP equivalent of Excel's COUNTIF function

    I'm trying to mimic this Excel-type behavior:  AB1failureTypenumFailuresThisType2f1=countif($a$2:$a$999,a2)3f2=countif($a$2:$a$999,a3)4f1=countif($a$2:$a$999,a4)5f1=countif($a$2:$a$999,a5)6f2=countif($a$2:$a$999,a6)......... ... in JMP.  Is this possible as a column formula? I've tried "Col Sum( :failureType == :failureType[ Row() ] )" but that doesn't work and I don't understand why.  Sometimes "...

    BHarris BHarris
    Discussions |
    Aug 22, 2024 1:06 PM
    4648 views | 14 replies

  • Countif equivalent?

    I am trying to find a JMP formula function equivalent to Excel’s Countif function, that points to a column and returns the number of rows that are the same as the value in the current row, as you would get if you did a Summary on that row. In other words, if I have a 1000-line table, and column Color is set to "Purple" in 27 rows, I want a formula for a new row that returns 27 for those rows (and ...

    DispersionSpark DispersionSpark
    Discussions |
    Aug 22, 2024 11:30 AM
    5421 views | 11 replies

Latest Discussions

  • select all the excluded cols, then delete?

    I'm working with a script that's doing some big data analysis on dt's with 10k+ cols. some of my first passes for screening these features results in excluding ~90% of the cols for further deeper analysis. In the interest of tidying up and reducing the dt, I want to select all the excluded cols and delete them. Any tips on how to script this? In my script, I am generating a colsList that is the 'k...

    TriangularLlama TriangularLlama
    Discussions |
    Aug 22, 2024 5:26 PM
    848 views | 1 replies

  • Looking for a formula to find the "elbow" in my data

    Hi JMP friends,(On regular JMP 18.0.1, example data attached)  I am analyzing some data wherein I need to find the time (x point) at which my data has an "elbow" or inflection. I have an initial mini-peak in my data and have been doing this work manually. However, this is slow and I would like to automate it, as I will be doing this for hundreds of tests that return graphs similar to the below, wi...

    RZordich RZordich
    Discussions |
    Aug 22, 2024 10:37 AM
    1785 views | 4 replies

  • Multi File Import Change Output Name

    I know this has been asked before, but I followed that solution and I cannot make it work. I am trying to import multiple files using MFI (which I can do), but it defaults to its own output table name. How do I change that output name (both scripting and where in the script)? Using JMP 17.    <JSL> // Import multiple files Multiple File Import( <<Set Folder( "C:\Users\bfkhp\OneDrive - grifols.com...

    patriciafm811 patriciafm811
    Discussions |
    Aug 22, 2024 9:41 AM
    1283 views | 3 replies

  • Machine data source list remove in "Database Operations"

    I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean

    Sean_ShCn0 Sean_ShCn0
    Discussions |
    Aug 22, 2024 7:24 AM
    748 views | 0 replies

  • Write Data from Data Table to Database

    Hello JMP-Community,I am searching your help here because I didn't found a sufficent solution for myself in other posts. It is about writing content of a data table into a table of a database.For that I wrote this little function: myInsertInto = function({dt, dbConnection, destinationName}, cols = dt << GetColumnNames(String); rows = dt << Select All Rows << GetSelectedRows; show(cols, rows); ...

    DBo_94 DBo_94
    Discussions |
    Aug 22, 2024 6:38 AM
    555 views | 0 replies

Latest Discussions

  • Machine data source list remove in "Database Operations"

    I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean

    Sean_ShCn0 Sean_ShCn0
    Discussions |
    Aug 22, 2024 7:24 AM
    748 views | 0 replies

  • Write Data from Data Table to Database

    Hello JMP-Community,I am searching your help here because I didn't found a sufficent solution for myself in other posts. It is about writing content of a data table into a table of a database.For that I wrote this little function: myInsertInto = function({dt, dbConnection, destinationName}, cols = dt << GetColumnNames(String); rows = dt << Select All Rows << GetSelectedRows; show(cols, rows); ...

    DBo_94 DBo_94
    Discussions |
    Aug 22, 2024 6:38 AM
    555 views | 0 replies

  • Is there a way to tell LCA that the rows are ordered by class?

    Typical dataset: 120-200 rows, 15 classes. Rows are known to be ordered by class. What is unknown is where the 'fences' between classes are. As-is -- i.e., without taking row order into account -- LCA correctly classifies about 94% of rows. My intuition is that if I knew how to tell the algorithm that the rows are grouped by class on input, we'd be at 100%. Visual, in case my use of 'grouped by' i...

    mtowle419 mtowle419
    Discussions |
    Aug 15, 2024 5:03 PM
    555 views | 0 replies

  • latin hyper cube

    Hi there, 

    I am attempting to run latin hyper cube with three continuous and one categorical factors, but the option is not available except for fast flexible filing design; can anyone assist me with this? thanks in advance

    H6Habib H6Habib
    Discussions |
    Aug 14, 2024 1:58 PM
    615 views | 0 replies

  • Characters as Markers: How to get rid of the shadows?

    I like the ability to add outlines to data points. This is very useful for separating partially overlapping data points.Unfortunately, when characters are used as markers, the outline mode looks very unprofessional - kind of like shadows, but without blur.Besides turning off the outline mode - is there a way to get rid of the "shadows"? (view in My Videos)  Names Default to Here(1); dt = Open( "$S...

    hogi hogi
    Discussions |
    Aug 9, 2024 3:04 AM
    524 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

Vroom! Vroom! Vroom! Join the JMP Summer Challenge: Motorsport edition

 view all blog articles

Learn more about JMP's premier analytics conference