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

  • 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
    2233 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
    3242 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
    2892 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
    2827 views | 3 replies

  • Issue with word and substring

    I am working on a data table with more than 4000 rows.To get the data in required format I'm using word and substr functions within for each row loop. The functions work as expected for first 160 rows and no action is taken on rows beyond this point.Is this a network issue ? I tried adding Wait but doesnt help. For Each Row(dt:col1 = Word(1,dt:col1, "S")); For Each Row(dt:col2 = Substr( Char(dt:c...

    ENTHU ENTHU
    Discussions |
    Nov 7, 2019 10:18 AM
    2797 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
    2233 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
    4160 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
    2928 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
    2713 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
    2199 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
    1932 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
    1299 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
    1338 views | 0 replies

  • Extract Report Data and Export it to Excel

    I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...

    jemairsmartes jemairsmartes
    Discussions |
    Sep 11, 2019 10:27 AM
    2136 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
    1376 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