cancel
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

Latest Discussions

  • Open file in excel with whitespace in filename

    Hi, Is it possible to open an Excel file from JMP where there is whitespace in the filename or path? Code from this post works where there is no whitespace: Solved: Open Excel File in Excel (Windows standard application) by JSL - JMP User Community     excel_file_to_open = Concat( "/X:/folder location/",excel_file_new_name); RP = Run Program( Executable( "C:\Program Files\Microsoft Office\root\Of...

    anna_717 anna_717
    Discussions |
    Nov 7, 2025 2:29 AM
    262 views | 2 replies
  • Is there a way to make a script for a JMP Database Query?

    In order to get traceability of our materials, I currently build a DB query to pull data from a table an Engineering table in our DB.   Can I create a script to do this?

    cjackso21 cjackso21
    Discussions |
    Nov 6, 2025 7:08 PM
    247 views | 1 replies
  • Step by Step Row "list" building: Get All Rows, then Get Rows Where X, then Get Rows Where Y (and X)

    I'm trying to understand working with objects that are containers of rows.  Even that description may be incorrect. What is "FilteredRows" in this context? dt = Current Data Table(); FilteredRows = dt << get rows where( :Date == 12May2025 ); Show( N Rows( FilteredRows ) ); To back up slightly, is there a JSL command to set an object to ALL rows in a datatable?  Or is that never necessary? The clos...

    MeanChris MeanChris
    Discussions |
    Nov 6, 2025 3:15 PM
    272 views | 2 replies
  • Python & JSL function

    From Python in JMP: dataframe column to datatable column best practices and computation speed implications I just learned about this nice new function:  import jmp jmp.globals['pi'] = 3.1415927 jmp.globals['bB'] = 'Bumble Bee' print( jmp.globals.items() ) to define variables in the JSL namespace - like a push version of Python Get()   There are some restrictions. E.g. , at the moment jmp.globals...

    hogi hogi
    Discussions |
    Nov 6, 2025 12:37 PM
    328 views | 3 replies
  • Python and Formula Columns

    Formula Column are very restrictive.
    If the entries of a JMP column are defined by a column formula , there is no possibility to change individual entries, neither manually nor via JSL:   dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << new column("row", Formula(row())) << run formulas; :row << suppress eval; Try(:row[5]=7, Caption("change a cell of a formula column via JSL? doesn't work")); Wait(2...

    hogi hogi
    Discussions |
    Nov 6, 2025 3:08 AM
    197 views | 0 replies

Latest Discussions

  • Is there a way to make a script for a JMP Database Query?

    In order to get traceability of our materials, I currently build a DB query to pull data from a table an Engineering table in our DB.   Can I create a script to do this?

    cjackso21 cjackso21
    Discussions |
    Nov 6, 2025 7:08 PM
    247 views | 1 replies
  • Python & JSL function

    From Python in JMP: dataframe column to datatable column best practices and computation speed implications I just learned about this nice new function:  import jmp jmp.globals['pi'] = 3.1415927 jmp.globals['bB'] = 'Bumble Bee' print( jmp.globals.items() ) to define variables in the JSL namespace - like a push version of Python Get()   There are some restrictions. E.g. , at the moment jmp.globals...

    hogi hogi
    Discussions |
    Nov 6, 2025 12:37 PM
    328 views | 3 replies
  • Python and Formula Columns

    Formula Column are very restrictive.
    If the entries of a JMP column are defined by a column formula , there is no possibility to change individual entries, neither manually nor via JSL:   dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << new column("row", Formula(row())) << run formulas; :row << suppress eval; Try(:row[5]=7, Caption("change a cell of a formula column via JSL? doesn't work")); Wait(2...

    hogi hogi
    Discussions |
    Nov 6, 2025 3:08 AM
    197 views | 0 replies
  • Throw() with traceback flag within a sub-function crashes JMP

    I 've encountered the following issue (minimal example below). Is this a bug or am I missing something? (Windows 11, JMP 18.0)

    The following script crashes JMP instead of simply throwing the error: Names Default To Here(1); f = Function( {}, { sub_f }, sub_f = Function( {}, If( 1, Throw( "thrown", 1 ) ); Return( "ok" ) ); Return( sub_f() ) ); f() In contrast to the above, without th...

    AlterEgo AlterEgo
    Discussions |
    Oct 31, 2025 6:40 PM
    238 views | 1 replies
  • Scripting the same output for all levels of a categorical variable

    Hi, I have a script that performs some calculations, runs some platforms and extracts certain output, and then builds a tab box in a new window. I want to do all of this for each level of some categorical variable that the user specified in my dialog box.   Currently I create individual subsets of the data based on my grouping variable, and then loop through each of those datasets: dtSubset = dt ...

    rcast15 rcast15
    Discussions |
    Oct 30, 2025 10:53 AM
    695 views | 6 replies

Latest Discussions

  • Python and Formula Columns

    Formula Column are very restrictive.
    If the entries of a JMP column are defined by a column formula , there is no possibility to change individual entries, neither manually nor via JSL:   dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << new column("row", Formula(row())) << run formulas; :row << suppress eval; Try(:row[5]=7, Caption("change a cell of a formula column via JSL? doesn't work")); Wait(2...

    hogi hogi
    Discussions |
    Nov 6, 2025 3:08 AM
    197 views | 0 replies
  • Windows 11 > JMP 17.2 > Fit Model > Contrasts > How to Build a Contrast Matrix with More Columns than Conditions?

    Hi JMP Community, When building contrasts in a Regular Least Squares Fit Model analysis, the number of columns (i.e., discrete contrasts) is limited to the number of conditions (i.e., number of items produced by the combinations of all parameters). In many cases, I'd like to create more contrasts than conditions (i.e., comparisons of multiple pairs of factor combinations)  Example: VAR1 = A, B, C ...

    Thierry_S Thierry_S
    Discussions |
    Oct 30, 2025 9:04 AM
    187 views | 0 replies
  • WINDOWS > JMP 17.2 > Custom Report Window > Save Presentation ==> Only portion saved to PPTX

    Hi JMP Community, I built a simple report with a graph builder plot, a multicolumn text section, and a summary section (see below)  that I would like to export to PowerPoint. While I can save this report as a PDF without any problems, when I save it as a Presentation/PowerPoint manually or within the script, JMP generates slides that only contain the plot section and none of the text (GO GENES and...

    Thierry_S Thierry_S
    Discussions |
    Oct 20, 2025 8:06 AM
    255 views | 0 replies
  • Workarounds

    very simple tasks - JMP says NO.   TaskJMP saysworkaroundswishimplementedadd column via Tables/Updatecolumn existsrename one of the columnsAllow Update platform to create new columns if they already exist in the table to be updatedv19copy a cellformula column- recode to dummy column | copy cell | delete dummy column
    - screenshot | OCREdit Pane allows for text copy even if no edit                   ...

    hogi hogi
    Discussions |
    Oct 7, 2025 3:51 PM
    311 views | 0 replies
  • How to export a model formula to Excel?

    I want to be able to take the prediction formula that I got from my multiple linear regression and put it in excel. I have multiple Quantitative and Categorical X variables and some are splined. I have also preformed a BoxCox transformation. What are the steps that I need to do to take the formula that is given and have it working in excel. I have no coding experience but am not against learning a...

    DWS DWS
    Discussions |
    Jun 13, 2025 8:33 AM
    517 views | 0 replies
view all discussions