cancel
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
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • 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
    3237 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
    2891 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
    2796 views | 3 replies
  • Functional Data: missing values imputation?

    Hello, I have a collection of X,Y curves I would like to analyize with Functional Data Explorer.  The problem I'm facing is that some of these curves are truncated at a certain value of X  because for greater values  a physical failure occurs during data collection. Some other curves reach the maximum possible X with no failure.  FDE is appearently not managing very well the presence of curves wit...

    matteo_patelmo matteo_patelmo
    Discussions |
    Nov 7, 2019 4:55 AM
    4581 views | 5 replies

Latest Discussions

  • 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
    4151 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
    2926 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
    2711 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
    2193 views | 3 replies
  • access and repeat row values

    I am trying to write a code where I can get value from a row and then repeat it in 13 successive rows of the same column.I want to read value from row number 15 and repeat in rows 16 to 28.Then read value from row number 29 and repeat until row 43 so on and so forth.How can I do this in jsl? Thanks

    ENTHU ENTHU
    Discussions |
    Nov 5, 2019 3:54 PM
    2446 views | 2 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
    1930 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