User Community
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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

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

view all learning resources

Latest Discussions

  • Combining multiple datasheets into one mastersheet - Can "Table Join" create with creating multiple columns" ?

    Hello - I usually work with big datasets with multiple sheets provided in xls format.I usually prework those sheets in excel with pivot tables and match functions to combine the multiple lists into into one mastersheet , so that every individual row represents one individual case with multiple variables in columns. A sample is displayed here - ID as unique identifier - weight - [Code 101, Code 102...

    marc1 marc1
    Discussions |
    Nov 9, 2019 7:36 AM
    5660 views | 2 replies

  • How do I convert a timestamp to a duration format?

    I would like to convert a column containing timestamp data in the numeric "ddMonyyyy h:m:s" time format to a numeric time duration format in seconds, starting the duration in the first row of my datatable.

    WHG WHG
    Discussions |
    Nov 8, 2019 5:10 AM
    2398 views | 1 replies

  • Run saved scripts after a data table update

    Hi, I saved a lot of scripts in a data table that I want to keep using after a major update of my data matrix, is this possible? How?Thanks for advice, Frank

    frankderuyck frankderuyck
    Discussions |
    Nov 8, 2019 2:07 AM
    3553 views | 4 replies

  • Increment a counter from 1 to n for every unique set of identical rows

    Hi everyone,   I figure what I want to do is really easy, I just haven't come up with a good way to do it. I have a large table with a substantial number of identical rows which I want to rename uniquely but in a reproducible way. Currently, I have a script that takes the following column:   A number 1 B number 1 A number 2 A number 3 A number 3 A number 3 B number 3 B number 3 B number 3 ...   In...

    screech screech
    Discussions |
    Nov 7, 2019 11:58 AM
    3191 views | 1 replies

  • select where statement for column value comparision

    Got back to JSL after a long break and feeling rusty.Can't get a select where statement work.I'm sure it's pretty simple.I'm trying to select rows by comparing a value with values in two other columns. dt << select where( :Col1 > :Col2 & :Col1< :Col3);Col1 is character(on purpose) because it needs to be used further and Col2,Col3 are numeric cols.What is wrong?I even tried doing this from GUI but ...

    ENTHU ENTHU
    Discussions |
    Nov 7, 2019 11:18 AM
    3076 views | 3 replies

Latest Discussions

  • How do I convert a timestamp to a duration format?

    I would like to convert a column containing timestamp data in the numeric "ddMonyyyy h:m:s" time format to a numeric time duration format in seconds, starting the duration in the first row of my datatable.

    WHG WHG
    Discussions |
    Nov 8, 2019 5:10 AM
    2398 views | 1 replies

  • Finding the allowable limits for a factor to ensure low defect rates

    Hi, Anyone has any idea how do we find the allowable limits that a few factors can operate in order to maintain a certain defect rates.  This video from robert actually shows how to find the best settings in order to achieve lowest defect rate with the assumption of normal distribution in these factors. What I am looking for is how do i determine what is the maximum variation allowable in order to...

    albiruni81 albiruni81
    Discussions |
    Nov 6, 2019 11:58 AM
    4608 views | 7 replies

  • How to optimize formula columns for faster recalculation speed?

    I have a fairly large JMP data table (132k rows, 2860 columns) which also has a large number of formula columns (200+).  I regularly import new data into this file, so I want to keep all of the formula columns "live" so they will auto-populate when new data is added.  I've started to run into issues with the speed of formula recalculation. At first the formulas were mostly simple arithmetic (addit...

    Chris_Rodrigues Chris_Rodrigues
    Discussions |
    Nov 6, 2019 8:45 AM
    3213 views | 2 replies

  • How Can I konw if the aliasing exists in the Alias Matrix?

    How Can I konw if the aliasing exists in the Alias Matrixthe involving two-way interactions and main effects? For example, in this Alias Matrix, what does 1 and 0 mean?

    Daa1029 Daa1029
    Discussions |
    Nov 6, 2019 6:48 AM
    2995 views | 3 replies

  • Create a column based on values on other columns

    I am trying to write a script whose values depend on the value of another column.I need to create a new column i.e second column below.Need to assign vales as followsSun = 1,Mon = 2 and so on.(4) => 2 , (6) => 4,5 => 1, 7 => 3Eg : Sun(5) is 11.How can I script this?Sat (4)72Sun (5)11Sun (4)12Mon (5)21Mon (4)22Tue (5)31Tue (4)32Wed (5)41Fri (7)63Wed (6)44Thu (7)53Thu (6)54Fri (6)64Sat (7)73

    ENTHU ENTHU
    Discussions |
    Nov 5, 2019 7:08 PM
    2435 views | 3 replies

Latest Discussions

  • How can I run a .py python script and python scripts compiled as .exe from JMP

    Hello,  So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe  (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...

    xxvvcczz xxvvcczz
    Discussions |
    Oct 30, 2019 6:44 PM
    2077 views | 0 replies

  • Analysis of covariance (ANCOVA) for Split plot Design

    Hi, I have a problem where I want to do ANCOVA and It is new for me.We have,Main plot data (2 treatments)Subplot data (10 treatments)Yield datawe want to add lodging (%) score as a covariate. How to do it? (I have seen some video tutorial from Youtube but its not easy to understand for me) Your cooperation will be highly appreciated.

    Harun-Or-Rashid Harun-Or-Rashid
    Discussions |
    Oct 29, 2019 9:03 PM
    1437 views | 0 replies

  • Send Expects Scriptable Object in access or evaluation of 'Send' Error

    I create a new window with variability chart, and put into journal. After that i want to save into pdf. But at the last line to save into PDF, it give me error like below. and nothing is saved into pdf. Need some advice which part i am doing wrong?  ErrorSend Expects Scriptable Object in access or evaluation of 'Send' , report_R235 << /*###*/SavePDF( "C:\LimTY\NXP\Product\Pegasus\Characterization\...

    OneNorthJMP OneNorthJMP
    Discussions |
    Oct 10, 2019 8:43 PM
    1432 views | 0 replies

  • How to Add Profit Matrix to Neural Net Confusion Matrix

    Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...

    GhostBen GhostBen
    Discussions |
    Aug 5, 2019 8:00 PM
    1506 views | 0 replies

  • Capability Animation - How to see the LSL/USL Value?

    I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?

    Antonio80 Antonio80
    Discussions |
    Jul 9, 2019 1:31 AM
    1478 views | 0 replies
view all discussions

JMP Events

Sorrento, Italy 10-12 March
view all events
Latest Blog Post

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration

JMP blog post photo
view all blog articles

Learn more about JMP's premier analytics conference