cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.

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

  • Create subsets from huge table (3,632,135 rows)

    Hi all, I have a big dataset with more than 3 million rows. The table contains 1105 ID (0-1104). Each ID has 3287 rows. So, I want to create 3287 subsets, and each subset contains 1105 ID lines.Could you please help me to find the solution?I attached the part of the dataset. 

    giaMSU giaMSU
    Discussions |
    Apr 2, 2021 2:45 PM
    1153 views | 1 replies
  • How to repeat values in a column when they are strings

    Hi everyone!

    I've used this script below for numerical values If( Is Missing( :Name( "For Calc - Data1" ) ), Lag( :Name( "Data1" ), 1 ), :Name( "For Calc - Data1" ) )
    With the resulting table looking like this For Calc - Data1Data11212 12 123333 33     However I can't apply this same formula to a column that has strings or characters to result in the following data table because I get an error sa...

    user8421 user8421
    Discussions |
    Apr 2, 2021 1:49 PM
    1252 views | 1 replies
  • How do I join two tables based on timestamps that don't exactly match?

    Hi everyone! I am having an issue where I have Data Table 1 as shown below with a timestamp column and various columns of data TimestampColumn AColumn B02/08/2021 11:45 AMA1B102/08/2021 1:39 PMA2B202/08/2021 11:37 PMA3B302/13/2021 12:01 AMA4B402/13/2021 4:00 PMA5B502/13/2021 10:22 PMA6B602/18/2021 9:00 AMA7B702/18/2021 12:01 PMA8B802/21/2021 9:15 AMA9B902/21/2021 11:50 AMA10B1002/21/2021 3:00 PMA1...

    user8421 user8421
    Discussions |
    Apr 2, 2021 11:20 AM
    6042 views | 5 replies
  • Code Folding is catching too many lines

    I have set "if" blocks to be foldable,  and I have been using them like this    If (1==1, // comment abc    <foldable code block 1 > ); If (1==1, // comment xyz    <foldable code block 2 > );   But often, the first block will catch later blocks and fold them all together.   The code work without a problem, but is is sometimes hard to find the code, it is lost in the folds. Is there a solution to t...

    mann mann
    Discussions |
    Apr 2, 2021 8:36 AM
    2193 views | 5 replies
  • displaying x axes in multi panel graphs

    I've created a multipanel graph of two variables (SNA versus soil temperature) where I've divided the data in 4 classes based on another variable (soil moisture). The soil moisture data column was dragged into the "Wrap" area in Graph Builder. The journal editor I am would like to see x axes on the upper 2 panels.  Is there a way to display the full axes (tick marks and numbers) or just the tick m...

    JohnMarkham JohnMarkham
    Discussions |
    Apr 2, 2021 6:03 AM
    1425 views | 2 replies

Latest Discussions

  • Create subsets from huge table (3,632,135 rows)

    Hi all, I have a big dataset with more than 3 million rows. The table contains 1105 ID (0-1104). Each ID has 3287 rows. So, I want to create 3287 subsets, and each subset contains 1105 ID lines.Could you please help me to find the solution?I attached the part of the dataset. 

    giaMSU giaMSU
    Discussions |
    Apr 2, 2021 2:45 PM
    1153 views | 1 replies
  • How to repeat values in a column when they are strings

    Hi everyone!

    I've used this script below for numerical values If( Is Missing( :Name( "For Calc - Data1" ) ), Lag( :Name( "Data1" ), 1 ), :Name( "For Calc - Data1" ) )
    With the resulting table looking like this For Calc - Data1Data11212 12 123333 33     However I can't apply this same formula to a column that has strings or characters to result in the following data table because I get an error sa...

    user8421 user8421
    Discussions |
    Apr 2, 2021 1:49 PM
    1252 views | 1 replies
  • How do I join two tables based on timestamps that don't exactly match?

    Hi everyone! I am having an issue where I have Data Table 1 as shown below with a timestamp column and various columns of data TimestampColumn AColumn B02/08/2021 11:45 AMA1B102/08/2021 1:39 PMA2B202/08/2021 11:37 PMA3B302/13/2021 12:01 AMA4B402/13/2021 4:00 PMA5B502/13/2021 10:22 PMA6B602/18/2021 9:00 AMA7B702/18/2021 12:01 PMA8B802/21/2021 9:15 AMA9B902/21/2021 11:50 AMA10B1002/21/2021 3:00 PMA1...

    user8421 user8421
    Discussions |
    Apr 2, 2021 11:20 AM
    6042 views | 5 replies
  • Code Folding is catching too many lines

    I have set "if" blocks to be foldable,  and I have been using them like this    If (1==1, // comment abc    <foldable code block 1 > ); If (1==1, // comment xyz    <foldable code block 2 > );   But often, the first block will catch later blocks and fold them all together.   The code work without a problem, but is is sometimes hard to find the code, it is lost in the folds. Is there a solution to t...

    mann mann
    Discussions |
    Apr 2, 2021 8:36 AM
    2193 views | 5 replies
  • displaying x axes in multi panel graphs

    I've created a multipanel graph of two variables (SNA versus soil temperature) where I've divided the data in 4 classes based on another variable (soil moisture). The soil moisture data column was dragged into the "Wrap" area in Graph Builder. The journal editor I am would like to see x axes on the upper 2 panels.  Is there a way to display the full axes (tick marks and numbers) or just the tick m...

    JohnMarkham JohnMarkham
    Discussions |
    Apr 2, 2021 6:03 AM
    1425 views | 2 replies

Latest Discussions

  • Workflow ideas for new projects

    Hi all, 

    After a year of playing around with JMP, I'm extremely satisfied with using it as my main data exploration platform. However, I'm overwhelmed about the tremendous amount of ways I can begin to explore my data. When starting a new project, let's say a biomonitoring study for instance, where does one begin their workflow? Are there any literature on JMP for starting a project from beginning ...

    MikeDereviankin MikeDereviankin
    Discussions |
    Mar 30, 2021 1:41 PM
    1160 views | 0 replies
  • Manipulating data table properties (cell width/height) INSIDE application module

    Hello! I have created and Application consisting of data from multiple data tables, plotted it into few separate cross-linked graph builders and hosting one preview of data table (which has images, which is kind of the point). I would like to manipulate the cell width / height of the data table cells included into this application/dashboard, but the task seems impossible. For only the data table, ...

    plotMaster plotMaster
    Discussions |
    Mar 27, 2021 3:54 PM
    1407 views | 0 replies
  • What does it mean when the solution path for Elastic Net is not single-valued?

    Dear JMP Community,   (W10, 64-bit, JMP Pro 15.2.1)   I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...

    SDF1 SDF1
    Discussions |
    Feb 15, 2021 12:35 PM
    1331 views | 0 replies
  • Return number from specified row of calculation column in either a text edit box or number edit box in an add in

    Hello,  I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...

    tys5384 tys5384
    Discussions |
    Feb 15, 2021 7:33 AM
    1184 views | 0 replies
  • generalized regression

    How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.

    Mrubra Mrubra
    Discussions |
    Feb 3, 2021 2:31 PM
    1008 views | 0 replies
view all discussions