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

  • To open a file through JSL, how can I open the file in a shared way?

    For example, if I open a test.CSV file through JSL, how can I use other software to continue to add data to the test.CSV file and save it as a new one?
    Of course, there is no need to notify JMP when there is new data.  Thanks!

    lala lala
    Discussions |
    Mar 12, 2024 12:37 PM
    1022 views | 1 replies
  • 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
    2231 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

Latest Discussions

  • To open a file through JSL, how can I open the file in a shared way?

    For example, if I open a test.CSV file through JSL, how can I use other software to continue to add data to the test.CSV file and save it as a new one?
    Of course, there is no need to notify JMP when there is new data.  Thanks!

    lala lala
    Discussions |
    Mar 12, 2024 12:37 PM
    1022 views | 1 replies
  • 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
    1672 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

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