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

  • Calling column from column list in formula

    I'm quite sure I will feel stupid after seeing the answers but I currently have a brain hang up. I want to refer to a column from a list of columns in a new formula in JSL (for later looping over the list). Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); mylist= dt<< Get Column Names(); dt << New Column( "myCol", Numeric, "Continuous", Format( "Best", 12 ), Formula(:height...

    Feli Feli
    Discussions |
    Feb 25, 2022 1:31 AM
    1501 views | 2 replies

  • Regex help -

    hello, I need just some help to use Regex function --String is like --"Fine.2020.Optional.(Not)" Required -- "Fine_2020_Optional" I have tried couple of combination, but not able to get the result in one regex. I am using this type of Regex in my for loop script. Any help ? Thanks.  

    HSS HSS
    Discussions |
    Feb 24, 2022 7:24 PM
    8637 views | 11 replies

  • Concatenate values in a column

    Seems like this should be simple, but I cannot find a clear example. I would like to concatinate the values in columns of a specific name("ROW" and "COL") and create a new column with the result in it. Example below. ROW COL CELL5 1 5_13 2 3_212 -1 12_-1 best shot at code so far: column("ROW") << Data type(Character); column("COL") << Data type(Character); //a = {column("ROW"), column("COL")}; ...

    ladomiqo ladomiqo
    Discussions |
    Feb 24, 2022 2:11 PM
    1791 views | 5 replies

  • How to show only significant correlation (>= .6) in a large correlation matrix

    I have 33 Likert scale variables that measure different types of disabilities from facial expression to speech, etc. The total score across all 33 scores gives a good index of an overall disability level. However, I found out that some items are highly correlated and perhaps redundant. I ran a correlation matrix for the 33 items in JMP Pro 16 that produced a huge table with the majority of correla...

    helalmob helalmob
    Discussions |
    Feb 24, 2022 1:44 PM
    2785 views | 3 replies

  • Simple start for script

    Hi I am a bit embarrased that I get stuck on this simple task.   It is a simple task: I have 2 data-tables (dt-1 and dt-2). I want to step through the first and for each row compare a value with a value in the second table, starting with first row in that table. If it is close enough I will collect a value from that dt-2 and save in a field in dt-1, put a special marker in a field in dt-2 so I kno...

    gueriniere gueriniere
    Discussions |
    Feb 24, 2022 11:11 AM
    1769 views | 3 replies

Latest Discussions

  • Concatenate values in a column

    Seems like this should be simple, but I cannot find a clear example. I would like to concatinate the values in columns of a specific name("ROW" and "COL") and create a new column with the result in it. Example below. ROW COL CELL5 1 5_13 2 3_212 -1 12_-1 best shot at code so far: column("ROW") << Data type(Character); column("COL") << Data type(Character); //a = {column("ROW"), column("COL")}; ...

    ladomiqo ladomiqo
    Discussions |
    Feb 24, 2022 2:11 PM
    1791 views | 5 replies

  • Adding constraints to design with discrete factors

    Hello,I am trying to add constraints to design with 4 discrete factors (X1,X2,X3,X4), where all the factors have 3 levels. What is the best way to add constraint to specify that three factors (X2,X3,X4) should add up to 97%? I am assuming I'll have to add disallowed combinations script option for this but not sure about the script.

    billi billi
    Discussions |
    Feb 24, 2022 8:36 AM
    976 views | 2 replies

  • MSA Gauge R&R AIAG Version?

    Hallo!JMP Verion 16.1Vorrede zu meinen Daten:Ich möchte einen Datensatz (2 nahezu gleiche Messysteme, darauf jeweils die 10 gleichen Personen mit 5 Wiederholungen gemessen) auswerten und den Varianzanteil durch die verscheidnen Massysteme zu erhalten. Dazu kann ich ja Gauge R&R oder EMP zur Analyse verwenden. Da alles mit dem gleichen Bediener gemessen wurde, würde ich bei der Analyse die 2 Messys...

    CountableMarten CountableMarten
    Discussions |
    Feb 24, 2022 8:23 AM
    2252 views | 4 replies

  • How to set values for last 30 rows of a column?

    Hi guys, I'm a complete scripting newbie here so please have patience with me .  I have a data set with multiple columns and am trying to make a script that will automatically select the last 30 rows of a column and change the content from "baseline" to "CLCR". Please see my attempt: dt = Current Data Table(); dt1 = dt << Select Columns( :CLCR ); dt1 << select where( Row() > N Rows( dt ) - 30 ); d...

    kkrog kkrog
    Discussions |
    Feb 24, 2022 1:07 AM
    1496 views | 1 replies

  • Conditional If then to return values for ranges

    I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number  19,20,21,22,23,24,25,26,27 etc.)

    ByrdQuestions ByrdQuestions
    Discussions |
    Feb 23, 2022 3:11 PM
    1452 views | 2 replies

Latest Discussions

  • No table linking after saving the project?

    Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...

    hogi hogi
    Discussions |
    Feb 3, 2022 4:19 AM
    598 views | 0 replies

  • Setting Guardbands on Test Limits Using EMP

    Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...

    Jbritsch04 Jbritsch04
    Discussions |
    Feb 2, 2022 8:49 AM
    769 views | 0 replies

  • How to introduce lower bounds for simulated data in Profiler platform

    Hi JMP community,   (JMP Pro 16.0.0)   I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...

    SDF1 SDF1
    Discussions |
    Feb 1, 2022 11:09 AM
    589 views | 0 replies

  • Query Builder filtering on date stored in Varchar(20)

    Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO]      ,[DESPA...

    HansD HansD
    Discussions |
    Jan 25, 2022 6:12 AM
    1391 views | 0 replies

  • M1 Macbook Pro JMP Capabilities

    Hi all, 
    I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...

    MikeDereviankin MikeDereviankin
    Discussions |
    Jan 21, 2022 1:52 PM
    789 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