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: 

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

  • Script for removing duplicate rows

    Hi, I have a script where I update a table by another one.For the final table, I would like to remove duplicate rows based on defined columns.Thereby, the row with the lower row number should be deleted.  In the following you can see an example for better illustration: RowDateABCD122.10.2021110415223.10.2021215827326.10.2021325 425.10.2021471312526.10.20213256 For this table, the duplicate rows ar...

    Konstantinos Konstantinos
    Discussions |
    Oct 28, 2021 4:30 AM
    3046 views | 4 replies

  • the formulas of a script don't apply

    hi,I wrote a script to import an excel sheet.Some formulas do not apply.  you can see the extract of the script with the formulas.the data base after running script with some empties columns (the formulas don't apply);if I make "Apply" in the colum property, then the formula apply.I don't understand why. best regards.  

    Françoise Françoise
    Discussions |
    Oct 27, 2021 11:55 PM
    826 views | 1 replies

  • Get Column Names from List of Columns

     Names Default to Here(1); dt = Current Data Table(); column list = dt << Get Column Names(Continuous); key list = dt << Get Column Group("KEYS");"column list" contains a list of names from columns containing continuous data."key list" contains a list of columns in the "KEYS" group.  How do I get the names of the columns from "key list"? Ultimately I would like to remove any continuous column nam...

    MarkDayton MarkDayton
    Discussions |
    Oct 27, 2021 11:15 PM
    15728 views | 7 replies

  • Script used to work in JMP14 but not working in JMP16

    Hi all,         I just encountered 2 problems with my script in a Modal Window which used to be working fine in JMP14 but as soon as I moved over JMP16, these 2 problems were found: 1) There's an error message came out stating "deleted object reference: cc << Get Selected in access or evaluation of 'Glue',....." 2) "Cancel" button shows an error " Name Unresolved: Button in access or evaluation of...

    brandon_mcrv brandon_mcrv
    Discussions |
    Oct 27, 2021 8:47 PM
    1908 views | 2 replies

  • JSL help: How can I open an excel spreadsheets and delete duplicates?

    I have my script (from the excel import wizard) as well as the example attached. All those columns are there but I just removed the data.  I am mainly looking to open an excel spreadsheet and only keep columns B and C while also deleting duplicate rows. I keep getting errors when debugging that the  This is my script so far. I don't have a duplicate delete portion because I keep trying to deal wit...

    Hobbi Hobbi
    Discussions |
    Oct 27, 2021 1:47 PM
    2662 views | 2 replies

Latest Discussions

  • Script for removing duplicate rows

    Hi, I have a script where I update a table by another one.For the final table, I would like to remove duplicate rows based on defined columns.Thereby, the row with the lower row number should be deleted.  In the following you can see an example for better illustration: RowDateABCD122.10.2021110415223.10.2021215827326.10.2021325 425.10.2021471312526.10.20213256 For this table, the duplicate rows ar...

    Konstantinos Konstantinos
    Discussions |
    Oct 28, 2021 4:30 AM
    3046 views | 4 replies

  • the formulas of a script don't apply

    hi,I wrote a script to import an excel sheet.Some formulas do not apply.  you can see the extract of the script with the formulas.the data base after running script with some empties columns (the formulas don't apply);if I make "Apply" in the colum property, then the formula apply.I don't understand why. best regards.  

    Françoise Françoise
    Discussions |
    Oct 27, 2021 11:55 PM
    826 views | 1 replies

  • User Input List for Regression Analysis

    I have an input box where users can select columns to be run in a regression report. (Long story on why I want to do this.) This part works great. I then insert the list of columns into a list. When I try to put the list or even just a few of the column names into the regression report. It doesn’t work. What should I do to make this work?   The user input list readout looks like this: {"Column 1",...

    dkraeuter_sunne dkraeuter_sunne
    Discussions |
    Oct 27, 2021 8:10 AM
    1458 views | 2 replies

  • I/O Problem. Unable to get End of File marker. Unable to get End of File marker.

    Hi, I have a problem with my script.I am running a script that modifies a data table which will be saved after the change (not closed). Other colleagues use this file (only read, not write mode). But unfortunately, I got now different types of error messages within the Log window. And on top the file is not saved. The messages are:I/O Problem. Unable to get End of File marker.I/O Problem. "somthin...

    mkennke mkennke
    Discussions |
    Oct 27, 2021 2:38 AM
    5200 views | 2 replies

  • JMP script to substract column value, if nth column have no data i need to take N-1 column value

    Hi Team, Please help to suggest some solution for below issueNeed to create a script that can work in both situation,column 8 = column 7-column6 but if column 6 is having empty cell then , column 8 = column 7-column 5 Note: column name is variable controlInput:   

    jinsejoseph jinsejoseph
    Discussions |
    Oct 26, 2021 2:20 PM
    1365 views | 3 replies

Latest Discussions

  • Variability Chart Platform Factor Re-Insert Positions (Not Swapping)

    Hello JMP Community, I understand dragging between any two factors swaps the location pairs in the Variability Chart platform. Is there a way to drag to specifically re-insert the factors instead? For example, can I drag "Layout" between "Horizontal" and "Wafer ID" in the attached screenshot instead of performing multiple drags to have the intended result? I am aware I can do this reordering with ...

    Technician Technician
    Discussions |
    Oct 26, 2021 11:04 AM
    1176 views | 0 replies

  • how can I use structural equation model to make predictions?

    Hi, I built a structural equation model and it works well. I would like use the model to make some predictions. Basically, what I want to do is to change the value of a variable and then JMP can calculate the values of other variables. Is there any way i can output the model equation so that I can use it to predict? Thanks.

    lujc07 lujc07
    Discussions |
    Oct 22, 2021 11:54 AM
    731 views | 0 replies

  • Get (x & y) intercept values from linear fit of the linear region of a curve/data and store them in a new column

    I have JMP data table with data from several parts for which a Capacitance 'C' has been measured as a function of reverse voltage 'V' (0 to -5 V in -0.1V step). A plot of [1/C]^2 vs V has a linear part for small reverse bias (say from 0 V to -0.5V and data is available at 0, -0.1, -0.2, -03, -0.4 -0.5 V within this range). How to do a linear fit to the points between 0 to -5V for each part, extrac...

    Neo Neo
    Discussions |
    Oct 22, 2021 10:15 AM
    709 views | 0 replies

  • Debugger report for finding bottlenecks

    I'm trying to find bottlenecks in a large script with many includes.  I can run the debugger to profile the script but I'm wondering if there's a better way than just looking through each included script for the highest number.  I'm imagining a pareto.     Anyone know a good method to analyze script performance?  

    vince_faller vince_faller
    Discussions |
    Oct 22, 2021 7:31 AM
    664 views | 0 replies

  • world map server compatibility

    I have successfully used 1-2 world map servers in the past through GraphBuilder but am encountering issues recently (JMP Pro 16). I can't figure out if it's something on my/JMP's end, or the WMS themselves. For instance, the US government has all these presumably WMS-like mapping products:  Note: tiled services may show up as Web Map Tile Service (WMTS), rather than WMS. Most software that can loa...

    abmayfield abmayfield
    Discussions |
    Oct 22, 2021 4:56 AM
    759 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