cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace

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

  • Color code Top 5

    I would like to color code my table (so that all the charts and graphs I make follow the same). But I want to do it so that top 5 are red, middle 15 are yellow, and bottom 27 are green. There has to be an easy way to do this.  For context, I have all the CDC rate data for various diseases that I need to track for 2014-2021. I need to be able to compare the US to any of the states and have it show ...

    patriciafm811 patriciafm811
    Discussions |
    Oct 19, 2023 9:44 AM
    3298 views | 10 replies
  • Automate importing files

    I have imported an excel file using workflow and am editing the script to be more general. Within the import settings under Column names starts is a specific number but instead I want it to be when a specific condition is met (e.g. when row 5 column 2 says START with start being the column name).  Any help in the right direction is very appreciated.   The snippet of code is below with the importan...

    MedianRooster10 MedianRooster10
    Discussions |
    Oct 19, 2023 9:36 AM
    756 views | 2 replies
  • Open Multiple files in different folders

    I have experimental results in 2 different formats as excel files under different folders depending on the conditions of the experiment. Is there a way for the user to state the parent directory and then JMP will open all the excel files as data tables?I also need need to be able to state the row the data starts on depending on which format the file is so that the column names are correct. I have ...

    MedianRooster10 MedianRooster10
    Discussions |
    Oct 19, 2023 5:36 AM
    1069 views | 1 replies
  • How to open a SAS file in sas7bdat format using JSL?

    Thanks!Opening the file directly with JMP shows different results

    lala lala
    Discussions |
    Oct 19, 2023 12:39 AM
    937 views | 2 replies
  • JSL: How to correctly pass variable values from one Expr() to another Expr()

    Hi All,   I'm having difficulty with variables that evaluate normally in one Expr1() not evaluating properly in another Expr2() that calls the first Expr. I have some code where I've defined an Expr1() that generates distributions of columns of interest. I have another expression later on, Expr2() that calls back to Expr1(). There are variables in Expr1() that appear not to evaluate properly in Ex...

    SDF1 SDF1
    Discussions |
    Oct 18, 2023 11:19 AM
    1140 views | 3 replies

Latest Discussions

  • Automate importing files

    I have imported an excel file using workflow and am editing the script to be more general. Within the import settings under Column names starts is a specific number but instead I want it to be when a specific condition is met (e.g. when row 5 column 2 says START with start being the column name).  Any help in the right direction is very appreciated.   The snippet of code is below with the importan...

    MedianRooster10 MedianRooster10
    Discussions |
    Oct 19, 2023 9:36 AM
    756 views | 2 replies
  • How do I change the number of decimals shown for a distribution plot?

    Hi,We recently moved from JMP 11 to JMP 13, and now the output of DoE looks different. In particular, more decimal points are shown than before (see screenshot). We want to avoid redoing all previous reports, so is there a way we can set the number of decimals in the distribution?Any feedback is highly appreciated!Sasker

    Sasker Sasker
    Discussions |
    Oct 18, 2023 9:52 AM
    4069 views | 4 replies
  • How to use JSL to replace characters with special symbols in ""?

    [{"ReqId":"200904","PoolId":"2001"}]How to[{\!"ReqId\!":\!"200904\!",\!"PoolId\!":\!"2001\!"}]Thanks!

    lala lala
    Discussions |
    Oct 17, 2023 9:44 PM
    1358 views | 6 replies
  • Get currently executing line number of script as a variable

    I'd like to send progress messages to the log that include the currently executing line number of the script. If I never changed the script of course I could just hard-code the line number into the message. But when I add/delete lines in the course of editing, the line numbers change. So is there a function that gives you the currently executing line number, so I could incorporate something likeWr...

    john_madden john_madden
    Discussions |
    Oct 17, 2023 5:32 PM
    1106 views | 2 replies
  • Is it possible to have independent x-axis ordering within x-axis groups in graph builder?

    In the attached data table the saved script plots the chart below.I want the x-axis parameter bars to change in order with the highest number of fails appearing first within each week (i.e. a Pareto type plot within each week)I created a FailOrder column for ordering within each week, but it does not seem to do what I want. Is there a way, via JSL, to have the order of the parameters (Para) in asc...

    Neo Neo
    Discussions |
    Oct 17, 2023 7:33 AM
    465 views | 0 replies

Latest Discussions

  • Is it possible to have independent x-axis ordering within x-axis groups in graph builder?

    In the attached data table the saved script plots the chart below.I want the x-axis parameter bars to change in order with the highest number of fails appearing first within each week (i.e. a Pareto type plot within each week)I created a FailOrder column for ordering within each week, but it does not seem to do what I want. Is there a way, via JSL, to have the order of the parameters (Para) in asc...

    Neo Neo
    Discussions |
    Oct 17, 2023 7:33 AM
    465 views | 0 replies
  • Strange behavior using GenReg and Forward Selection

    Hi All,   I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method.   So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...

    SDF1 SDF1
    Discussions |
    Oct 2, 2023 9:06 AM
    472 views | 0 replies
  • SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?

    Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method?  I am currently using JMP 17 Thank you very much...

    CamillaLiscio CamillaLiscio
    Discussions |
    Oct 2, 2023 5:55 AM
    743 views | 0 replies
  • What determines which data table is seen as "Associated Data" for New Window?

    What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)?   This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...

    jthi jthi
    Discussions |
    Sep 21, 2023 9:44 AM
    512 views | 0 replies
  • Using R - File path problem

    I have difficult to get the filepath correct. 
    Error message says "Cannot open table in access or evaluation of ....(Filepath)"   

    Prometheus Prometheus
    Discussions |
    Sep 17, 2023 10:46 PM
    622 views | 0 replies
view all discussions