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: 
  • 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
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

  • Append JMP Data Table into SQL database with Dates

    Hi everyone, I'm trying to upload my data table into SQL & I'm having issues getting the date columns to load in.

    The error I receive is this: "[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: numeric is incompatible with date"I tried using SELECT CAST to make it into a date format but that didn't work. I'm using JMP 17.0.0. I used the base code from this post & tried to adapt it ...

    Bagawandoss96 Bagawandoss96
    Discussions |
    Sep 21, 2023 5:00 AM
    1123 views | 1 replies

  • Simple filter question

    I am trying to do a simple filter and save it to my table so I have the script for later use. 
    Basically I want my table to only show rows for a specific water meter, and then change the filter to show the rows only for another water meter. 
    This is because I know that one has more rows in the dataset than the others have... I also know through analysis in powerbi, that the scew is because one meter...

    Prometheus Prometheus
    Discussions |
    Sep 20, 2023 11:03 PM
    1996 views | 3 replies

  • Is there a way to capture logs without silencing exceptions?

    In my test framework I would like to cut out the clutter that results from Prints/Writes/handled exceptions from my output file, so I tried executing test code inside of a Log Capture( Eval( testExpression ) ). My problem is that this seems to also silence any exceptions that get thrown when evaluating the testExpression, which I did not expect. As an example:Try( logs = Log Capture( Throw( "n...

    mat-ski mat-ski
    Discussions |
    Sep 20, 2023 12:54 PM
    2172 views | 5 replies

  • I am trying to reset columns with a character ("<") to numeric and retain the "<" in another column

    Hi - I have a table with columns that are made up of lab results (numeric values) that were entered as a text string.  They are text string because some have a "<" in front of the numeric value.  I need to be able to perform numeric calculations on the values so I am trying to remove the "<" symbol and place it in a new column that is named "ORIGCOLNAME_QUALIFIER" (where ORIGCOLNAME is the name of...

    learning_JSL learning_JSL
    Discussions |
    Sep 20, 2023 12:16 PM
    3717 views | 9 replies

  • For big ATE test data - How to keep the col properties format to "Engineering SI" instead of default?

    I have 700 test data for 1k units in ATE (Semiconductor). It is not comfortable to use the default col properties as some units might be in nA and some might be in uA. I would like to have "Engineering SI" selected as default for all the 700 tests. Kindly help!

    Cognostar18 Cognostar18
    Discussions |
    Sep 20, 2023 11:38 AM
    1184 views | 1 replies

Latest Discussions

  • Append JMP Data Table into SQL database with Dates

    Hi everyone, I'm trying to upload my data table into SQL & I'm having issues getting the date columns to load in.

    The error I receive is this: "[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: numeric is incompatible with date"I tried using SELECT CAST to make it into a date format but that didn't work. I'm using JMP 17.0.0. I used the base code from this post & tried to adapt it ...

    Bagawandoss96 Bagawandoss96
    Discussions |
    Sep 21, 2023 5:00 AM
    1123 views | 1 replies

  • Simple filter question

    I am trying to do a simple filter and save it to my table so I have the script for later use. 
    Basically I want my table to only show rows for a specific water meter, and then change the filter to show the rows only for another water meter. 
    This is because I know that one has more rows in the dataset than the others have... I also know through analysis in powerbi, that the scew is because one meter...

    Prometheus Prometheus
    Discussions |
    Sep 20, 2023 11:03 PM
    1996 views | 3 replies

  • date

    Bonjour à tous, Je dispose d’une base de données comme ceci (il s’agit d’un résumé ici) : Cette base de données est issue d’un script qui fonctionne bien jusqu’ici, cependant la dernière colonne permettrait de calculer une dernière durée différente des autres.Les valeurs dans cette dernière colonne représentent des OP qui correspondent à des objets. Par exemple pour la 1ère ligne : la valeur 60 co...

    hcarr01 hcarr01
    Discussions |
    Sep 20, 2023 10:49 AM
    2082 views | 7 replies

  • Linearity assessment

    Dear all, I want to perform a regression for method comparison in laboratory using two types of data :- Data from a first analyzer in X axis which were performed in 1 run in duplicate (2 values)- Data from a new analyzer in Y axis which were performed in 2 run in duplicate (4 values) With regression data, I want then to perform least squares regression, lack of fit test and outlier test. Can anybo...

    cpuisney cpuisney
    Discussions |
    Sep 20, 2023 7:53 AM
    1773 views | 4 replies

  • Delta calculations

    I have a dataset with hourly observations the last three years og different water meters. 
    The issue is that the observations shows the meter stand, and not the water usage. 
    I want to calculate/show a delta change for each hour, for each water meter. How do I approach that? 

    Some of the analysis I want to make with this dataset is to find if a meter has a negative usage at one point (indicating wate...

    Prometheus Prometheus
    Discussions |
    Sep 20, 2023 5:49 AM
    7782 views | 18 replies

Latest Discussions

  • 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
    839 views | 0 replies

  • Data Access Handler

    How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties.  But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...

    hogi hogi
    Discussions |
    Sep 16, 2023 12:21 AM
    556 views | 0 replies

  • Use JMP Locale Settings( 0 ) not working on macOS

    It seems the following command does not work for JMP MacOS.   Use JMP Locale Settings( 0 )   Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user? // Configuring JMP to save CSV as commas and not If( (Num( "3.14" ) == 3.14), is_EN_num_format = 1, //"English numeric format" is_EN_num_format = 0 //"Non-english"); )...

    FN FN
    Discussions |
    Sep 15, 2023 10:21 AM
    669 views | 0 replies

  • Inherited Plot settings

    Hi,
    I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

    One example:
    If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...

    hogi hogi
    Discussions |
    Sep 14, 2023 11:11 PM
    648 views | 0 replies

  • Mixed model: which specifications for cross-over designs?

    I ran a cross-over trial where healthy volunteers came to the lab twice (separated by a wash-out period) and underwent sensory testing at both arm and foot, before and after one of two neuromodulation interventions. Each participant underwent both conditions in a randomly assigned order. We want to see if the neuromodulation interventions affected the outcomes differently for the arm and the foot....

    arnaudsteyaert arnaudsteyaert
    Discussions |
    Sep 13, 2023 7:30 AM
    841 views | 0 replies
view all discussions

JMP Events

view all events
Latest Blog Post

More on the many advantages of structural equation models

 view all blog articles

Learn more about JMP's premier analytics conference