cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

  • Data table - If one column has empty value, then use other column value to fill in,other row keep no change

    Names Default To Here( 1 ); //If the original data table is like below, // there are 2 empty value(:sex[3] and :sex[4] )in column sex: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt:sex[3 4] = black;   I want the function is: when search all values in column :sex, if find column sex have empty value, then fill the column :name value into the empty position in :sex while keep other value in :sex w...

    Theresa Theresa
    Discussions |
    Apr 9, 2021 2:33 AM
    1865 views | 1 replies
  • DSD with block - Should the block be included during analysis?

    Hi All,I've created a DSD DOE - 6 parameters with added blocks with center runs to estimate quadratic effects, in total of 18 runs.  DOE run, data obtained. now come the analysis part. I use this option to analyze the DSD DOE.   The question is: should the Block be included in the X-roles area?

    Thanks in advance,AmirSS

    AmirSS AmirSS
    Discussions |
    Apr 9, 2021 1:08 AM
    3777 views | 5 replies
  • JSL keep command to keep wanted variables and delete unwanted variables?

    I am looking for a JSL script command to "keep" only specified column variables, and delete all other variables in the current data table.This would be the inverse of the specified command:  dt << Delete Columns( :A, :B, ... :N);Ideally a more efficient keep command would appear like:dt = Current Data Table( );dt << Keep Columns ( :time, :day, :location );(outcome = Delete all columns that do not ...

    aandw aandw
    Discussions |
    Apr 8, 2021 2:22 PM
    13458 views | 5 replies
  • Moving column group to 'after column' is only moving it to the first

    ​I'm trying something that seems simple - moving a column group to a location after another column.   Moving "to last" works, "to first" works, but after doesn't for me, no matter how i mess with format.   Below is example code to test -   Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Cities.jmp" ); dt << group columns( "xy", {:X, :y} ); dt << group columns( "pollutants", :Ozone :: :Lead );...

    jetpeach jetpeach
    Discussions |
    Apr 8, 2021 1:54 PM
    7367 views | 3 replies
  • How to make a formula to pick out the minimum date from a row of data

    Hi there, I new to JMP and was wondering if someone could help me a question.I have multiple rows of data (that are dates) and I want to be able to another column which captures the earliest date from each row. Is there away to do that?Thanks. 

    Ash Ash
    Discussions |
    Apr 8, 2021 1:36 PM
    1615 views | 2 replies

Latest Discussions

  • Data table - If one column has empty value, then use other column value to fill in,other row keep no change

    Names Default To Here( 1 ); //If the original data table is like below, // there are 2 empty value(:sex[3] and :sex[4] )in column sex: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt:sex[3 4] = black;   I want the function is: when search all values in column :sex, if find column sex have empty value, then fill the column :name value into the empty position in :sex while keep other value in :sex w...

    Theresa Theresa
    Discussions |
    Apr 9, 2021 2:33 AM
    1865 views | 1 replies
  • How to make a formula to pick out the minimum date from a row of data

    Hi there, I new to JMP and was wondering if someone could help me a question.I have multiple rows of data (that are dates) and I want to be able to another column which captures the earliest date from each row. Is there away to do that?Thanks. 

    Ash Ash
    Discussions |
    Apr 8, 2021 1:36 PM
    1615 views | 2 replies
  • Plotting censored values in a Life Distribution

    I am building a model using the Life Distribution tool and get a nice plot that shows my failures.  Other tools I've used will allow me to plot my censored data, or suspensions, on top of this plot, but I cannot seem to figure out how to do it in JMP.  Has anyone figured out how to add the censored data in?  Using JSL to do this would be perfectly acceptable too, if anyone knows how to add this in...

    bfoulkes bfoulkes
    Discussions |
    Apr 8, 2021 1:22 PM
    18383 views | 11 replies
  • find first element with condition in a column

    Hi, I have a data with 2 columns: group and score, and I want to calculate the 3rd column called first, which returns the "first score by group that is not 10000000000. so in this sample data, group a = 0, group b =53. and since group c only contains 10000000000, nothing shows up for it.Could someone help me with a jmp formula for this column but not jsl? Thank you so much!groupscorefirsta10000000...

    joann joann
    Discussions |
    Apr 8, 2021 9:36 AM
    4405 views | 6 replies
  • Nominal factor in Prediction Profiler

    Dear community,I am trying to use the prediction profiler with one of the factors having the nominal data type.  In the example below, the Factor 1 can assume two values, “One” and “Two”. The formula to be profiled contains a ‘Match’ statement that selects the numerical value 1 or 2, according to which string (“One” or “Two”) is entered, see the example code:dt = New Table("Simulate",  Add Rows( 1...

    martin_snogdahl martin_snogdahl
    Discussions |
    Apr 8, 2021 8:19 AM
    7024 views | 7 replies

Latest Discussions

  • JSL Syntax Change is coming: Name() is being deprecated

    Hi All,   I just read here that the JSL syntax for referencing a column using the Name() parser is going away. The new syntax is currently in use and at some point the old syntax will be removed entirely. There's a lot of people here who script, so thought it would be good to post something here.   I know I have a lot of code I'll need to change! Better to be ahead of the curve and change it befor...

    SDF1 SDF1
    Discussions |
    Apr 7, 2021 10:14 AM
    885 views | 0 replies
  • 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
    1164 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
    1412 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
    1334 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
    1188 views | 0 replies
view all discussions