User Community
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 will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
JMP Bar Chart

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users

Learning Resources

Find courses, tutorials, and lots of other methods of learning JMP.

view all learning resources

Latest Discussions

  • Selecting a row from a string column if it contains a certain word

    I have a set of data called value 2 that has been entered as a character with the units at the end. Some of them are entered as ml/min and some as ul/s, and I'd like to separate the ones that are in ul/s into a new column entirely. What function should I use to select the rows that contain a certain subset of a string (I was going to select the ones that contain "ul/s" to enter them into a new col...

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 14, 2024 7:58 AM
    1714 views | 2 replies

  • Deleting Similar Rows

    I'm trying to create a script that will delete a row from my table if the ID and two values are the same as the row before it. I cant delete all duplicate rows because there is a "run number" column that is unique to each row. Does anyone know why my code isn't working?   // Delete Duplicate Rows (re-entries) NRows = N Rows(dt); For(i = 1, i <= NRows, i++, If( dt:ID[i] == dt:ID[i + 1] & Data T...

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 14, 2024 7:49 AM
    917 views | 1 replies

  • How to Process Continuous Alarm Data Using a JMP Script

    I want to count the number of times an alarm occurs in the process. The data comes in every second. When an alarm occurs, the data shows 1, and if the worker doesn’t turn off the alarm, the number 1 continues to appear.

    The problem is, if the alarm is not turned off within 10 seconds, it actually counts as one alarm but appears as 10 alarms in the data.

    I want to leave only one row and delete the re...

    Ronaldo Ronaldo
    Discussions |
    Jun 11, 2024 3:25 PM
    1362 views | 2 replies

  • Consolidating Repeated Values

    I have a table like this with an ID number and a value assigned to each. Some ID numbers were tested multiple times and so have multiple values. I've seen codes to remove all rows with duplicate ID numbers, but I'd like a code that deletes all rows with duplicate ID's BUT saves the value from the nth test under a new column (e.g. value 2, value 3, value n)... Any help would be greatly appreciated....

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 10, 2024 1:46 PM
    983 views | 1 replies

  • Data preparation- substract column data by other column

    Hi,I have a table with different scan results.I have 180 scans with 1000 results per scan.results are at the Z column.I want to create a new column with relative scan results, meaning the results of scan 2 - the results of scan 1, results of scan 3 - the results of scan 2, and so on.subtraction of results must be by Location number, 1-1, 2-2, 3-3, and so on.I've tried to transpose the data but got...

    Ohad_s Ohad_s
    Discussions |
    Jun 9, 2024 4:57 AM
    1937 views | 4 replies

Latest Discussions

  • Selecting a row from a string column if it contains a certain word

    I have a set of data called value 2 that has been entered as a character with the units at the end. Some of them are entered as ml/min and some as ul/s, and I'd like to separate the ones that are in ul/s into a new column entirely. What function should I use to select the rows that contain a certain subset of a string (I was going to select the ones that contain "ul/s" to enter them into a new col...

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 14, 2024 7:58 AM
    1714 views | 2 replies

  • Deleting Similar Rows

    I'm trying to create a script that will delete a row from my table if the ID and two values are the same as the row before it. I cant delete all duplicate rows because there is a "run number" column that is unique to each row. Does anyone know why my code isn't working?   // Delete Duplicate Rows (re-entries) NRows = N Rows(dt); For(i = 1, i <= NRows, i++, If( dt:ID[i] == dt:ID[i + 1] & Data T...

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 14, 2024 7:49 AM
    917 views | 1 replies

  • Consolidating Repeated Values

    I have a table like this with an ID number and a value assigned to each. Some ID numbers were tested multiple times and so have multiple values. I've seen codes to remove all rows with duplicate ID numbers, but I'd like a code that deletes all rows with duplicate ID's BUT saves the value from the nth test under a new column (e.g. value 2, value 3, value n)... Any help would be greatly appreciated....

    S_Boilermaker S_Boilermaker
    Discussions |
    Jun 10, 2024 1:46 PM
    983 views | 1 replies

  • How to convert decimal value to binary value in another column?

    How to convert decimal value to binary value in another column?

    Liranlev Liranlev
    Discussions |
    May 31, 2024 12:43 PM
    3784 views | 8 replies

  • Update column with formula

    Hi all,I have two data table (dt1 & dt2). I need to add dt2's column (Col1) to dt1 with a formula in it. But when I update the table, the values from Col1 are empty. Seems to be a problem in the formula. Please help current data table (dt1); dt1 << Update( With( dt2), Match Columns( :KeySample= :KeySample), Add Columns from Update table ( :Col1) ); dt1:Remarks << Formula ( If( :Col1== "Out of...

    UserID16644 UserID16644
    Discussions |
    May 30, 2024 11:53 AM
    2824 views | 5 replies

Latest Discussions

  • How to categorize the same ID in row with other columns?

    Hi, I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete categ...

    doraemengs doraemengs
    Discussions |
    Mar 25, 2024 9:12 PM
    1171 views | 0 replies

  • RSS, TSS, precent of residual sum of squares

    Is it possible to calculate RSS and TSS and precent of residual sum of squares for a linear calibration curve in JMP?

    gholamhasantey gholamhasantey
    Discussions |
    Mar 25, 2024 3:29 AM
    1091 views | 0 replies

  • Is there a way to change the defaults for the Summary platform?

    Hi All,   Does any know if it's possible to change the defaults of the Summary platform (Tables > Summary)?   By default, Summary sets the new column names to be stat(column) and checks that the new data table is linked to the original data table.  For much of the work I do, I don't like these features and wish I didn't have to change them every time I run a Summary. I know it can be useful at tim...

    SDF1 SDF1
    Discussions |
    Feb 29, 2024 8:08 AM
    745 views | 0 replies

  • Custom Binning - how to edit the bins?

    Wow, custom binning even works with dates, cool! There is even a possibility to edit the binning. But: quite uncomfortable to type in the dates in seconds and to correct the labels manually.What do I have to change in my workflow to be able to enter the "dates" in a usual format - and to get the labels adjusted automatically?

    (view in My Videos) dt = Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" ); d...

    hogi hogi
    Discussions |
    Jan 21, 2024 2:33 AM
    1060 views | 0 replies

  • Custom Binning - how to edit Transform Column settings?

    In Jmp16, Custom binning was introduced: Interactive Binning - New in JMP 16 Very useful, thanks a lot to the developers! There are 3 ways (or more?) to use this feature:In the data table, via the menu:  Col/Utilities/Make Binning Formula ...
    or via right click / New Formula Column/Distributional */Custom Binning ...


    for plot modes like Overlay, Color, X/Y Group, Page:
    via right click/Levels/Custom L...

    hogi hogi
    Discussions |
    Jan 19, 2024 10:50 PM
    800 views | 0 replies
view all discussions

JMP Events

Sorrento, Italy 10-12 March
view all events
Latest Blog Post

Revolutionizing Spectral Baseline Correction in JMP: Harness the Power of Python Integration

JMP blog post photo
view all blog articles

Learn more about JMP's premier analytics conference