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

  • Close Database connection

    Hi, Is there a way to close the database connection before running the script?I have an SQL script that crashes JMP if there's an open connection, so I'm trying to figure out a way to close all the connections before running the script. Thanks,

    Jackie_ Jackie_
    Discussions |
    Mar 12, 2024 11:45 AM
    1419 views | 2 replies

  • How to replace :column_name with variable in JMP JSL?

    @jthiCan you help me to fix the code error below? How to use variable to replace :column name in the correct way? Thank you so much for your help. Names Default To Here( 1 ); Open( "$SAMPLE_DATA/Big Class.jmp" ); hvar = "height"; gvar = "sex"; std = Col Std Dev( if(Excluded( Row State() ) == 0 & column(gvar) =="M", column(hvar) )); //std = Col Std Dev( if(Excluded( Row State() ) == 0 & :sex =="M...

    lazzybug lazzybug
    Discussions |
    Mar 12, 2024 8:53 AM
    2229 views | 3 replies

  • Downloading a file from web with header "content-disposition: attachment"

    I would like to download a csv file from a webpage, however when I send the HTTP request the return is Empty(). My code is as follows:request = New HTTP Request( URL( url), Method( "Get" ), Headers( {"Authorization: Bearer " || token} )); data = request << send;I receive the following response header, so I'm confident I am accessing the server: GetResponseHeaders = ["content-disposition" => "attac...

    BackwardEffect6 BackwardEffect6
    Discussions |
    Mar 12, 2024 4:14 AM
    2354 views | 1 replies

  • Return of an error to the user because of a wrong Excel file selected

    Hello, I would like to create a JMP program which returns an error to the user because he selected the wrong Excel file. Here is an example of my program:The  file_path contains the path to the file selected by the user.However, I would like to return a message error when the Worksheets( "AAA" ) is not contained in the Excel file selected by the user: because he didn't choose the right Excel file....

    Sebastienlg Sebastienlg
    Discussions |
    Mar 12, 2024 2:39 AM
    1444 views | 2 replies

  • Row Problem

    I have a two part question. I am trying to change the value of previous rows in a column based on data in another column and I'm having a couple of problems. In the example below, when the status changes from Status1 to anything else (note green cells), I want to change the value of the cell 6 rows up (red cell).  The column formula I am using is below.   As you can see from the table, the script ...

    scott1588 scott1588
    Discussions |
    Mar 12, 2024 12:23 AM
    1781 views | 3 replies

Latest Discussions

  • Close Database connection

    Hi, Is there a way to close the database connection before running the script?I have an SQL script that crashes JMP if there's an open connection, so I'm trying to figure out a way to close all the connections before running the script. Thanks,

    Jackie_ Jackie_
    Discussions |
    Mar 12, 2024 11:45 AM
    1419 views | 2 replies

  • Downloading a file from web with header "content-disposition: attachment"

    I would like to download a csv file from a webpage, however when I send the HTTP request the return is Empty(). My code is as follows:request = New HTTP Request( URL( url), Method( "Get" ), Headers( {"Authorization: Bearer " || token} )); data = request << send;I receive the following response header, so I'm confident I am accessing the server: GetResponseHeaders = ["content-disposition" => "attac...

    BackwardEffect6 BackwardEffect6
    Discussions |
    Mar 12, 2024 4:14 AM
    2354 views | 1 replies

  • How to multiply Y-Axis by 100?

    I am currently using Variability Chart in JMP 15. And one of the requirement is to multiply its Y-Axis by 100. Is it possible to multiply the Y-Axis by 100? How to do it?

    UserID16644 UserID16644
    Discussions |
    Mar 11, 2024 11:50 PM
    1671 views | 2 replies

  • How to query in SQL using list from JSL

    Hi all, How can I insert a list from JSL to my SQL query? Currently I am using this to get the list that I need: NameList = Associative array( dtNames:"Names" ) << Get Keys; And will use it as a SQL query dt = Open Database( "DSN=db;UID=uname;PWD=pw;APP=JMP;DATABASE=dbname;", "select name, age, address, sex from db_Details where name in ('"||NameList||"')", // Im getting an error here "Details" ...

    UserID16644 UserID16644
    Discussions |
    Mar 7, 2024 2:31 PM
    1408 views | 2 replies

  • Python: get error message?

    Python integration in jmp is very useful.For debugging - when I executing a command in Python  viaPython Submit()and get a return value -1, indicating that something went wrong. Is there a possibility to get the error message? e.g. an automatically updated Python variable, which I could get back to JSL via Python Get(PythonErrorMessage) #myTop10_2022
    -> JMP 18 : )

    hogi hogi
    Discussions |
    Mar 7, 2024 10:01 AM
    3569 views | 6 replies

Latest Discussions

  • DataTable Prompt in application builder on module load

    Hello guys, I have applciation builder with multiple modules. one of the module only contains column list which requires selection of datatable. How to make jmp prompt to select datatable only when that module loads.By default it prompts when the application loads  Kindly guide. Thanks in advance

    ComplexNerd ComplexNerd
    Discussions |
    Mar 7, 2024 3:54 AM
    662 views | 0 replies

  • JMP Project Global Data Filter and Column Switcher

    Hello Guys, I just started exploring jmp project. I am wondering if there is any option to add Global Data Filter and a global column switcher to a jmp project.Currely i have created a jmp project with various reports from a datatable (similar to dashboard) but i want to know if there is a option to add a global data filter and also a global column switcher to this screen. My idea : To create a sc...

    ComplexNerd ComplexNerd
    Discussions |
    Mar 7, 2024 12:10 AM
    621 views | 0 replies

  • "If" returns error response

    I have a script to draw charts and use "if" for the reference line."Sometimes" the reference line is not correct. For example, when Rel_Test=H3TRB, the reference line should be 10, but it shows 5.How could I fix it? 
    d6_graph=dt2 << Graph Builder( Size( 400, 300 ), Show Control Panel( 0 ), Variables( X( :Lot), Y( :dIGSS, Position( 1 ) ), Color( :Lot ), By(:Rel_Test) ), Elements( Box Pl    ...

    LT LT
    Discussions |
    Mar 4, 2024 8:08 PM
    942 views | 0 replies

  • Neural networks that learn and predict in real time (incremental learning)

    Hello community!!A query:- How JMP is configured to generate neural networks that learn from their inputs in real time (incremental learning) in such a way that it continually updates its weights according to new inputs and generates updated real-time predictions.Greetings,Marco

    Marco2024 Marco2024
    Discussions |
    Mar 4, 2024 9:37 AM
    850 views | 0 replies

  • group file name and set lable by JSL looping, work fine but slowly

    I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...

    BayesRabbit7133 BayesRabbit7133
    Discussions |
    Feb 22, 2024 12:24 AM
    861 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