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

  • JMP 17.2 > Workflow > Introduce break for user input?

    Hi JMP Community,   I finally upgraded JMP to version 17.2 (Windows) and would like to explore the Workflow tool added to that software version. Specifically, I would like to refine a standard workflow (recorded) to allow the user to select specific columns in the script. While I could edit the script manually (tedious), I want to know if there is a more straightforward way to insert an interactiv...

    Thierry_S Thierry_S
    Discussions |
    Mar 11, 2024 12:07 PM
    1202 views | 1 replies
  • getting lefthand offset between beginning of picture box and framebox from graphbuilder plot

    JMP Pro 17.2 I have a plot where I want to use both overlay (to separate lines) and color (to color related lines the same way). This works great, but I lose all colors when extracting the framebox. I can keep the colors by grabbing the picturebox, but I don't know how to calculate the left offset in the plot before where the x-axis begins. It seems like I should use the y-axis width plus the y-ax...

    Mittman Mittman
    Discussions |
    Mar 9, 2024 1:21 AM
    1206 views | 1 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
  • How to skip item on JSL list in SQL query if it does not exist?

    Hi all,I have a script that queries from JSL list. However, it gets an error whenever something is not existing on the database. Is there a way that I can skip what is not existing and proceed to the next value in the list? I have this example: NameList = {"John","Jane","Anna","Dominic"}; NameItems = ConcatItems(NameList ,","); Eval (Parse (Evalinsert("\[ db= Open Database("Server Specs", "SELE...

    UserID16644 UserID16644
    Discussions |
    Mar 7, 2024 11:40 AM
    1760 views | 2 replies
  • Name Unresolved for column name when using Match function

    Hi, I have a script that pulls a query then I attempt to recode some of the query information. whenever I run the "match" function in a separate script it works but when I combine it into my full script I get the error: "Name Unresolved: SamplePoint at row 1 in access or evaluation of 'SamplePoint' , SamplePoint/*###*/"   SamplePoint is the column I'm trying to recode   Here is the full code:  //!...

    Bluebird73 Bluebird73
    Discussions |
    Mar 7, 2024 11:20 AM
    1566 views | 1 replies

Latest Discussions

  • 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
  • Importation of an Excel file encrypted with a password in JMP

    Hello all,I would like an Excel file encrypted with a password in JMP.However, when I import the file, JMP ask me 3 times the password.Is there a way to import an encrypted Excel file by asking the password only once?Thanks a lot for your answer,Sébastien

    Sebastienlg Sebastienlg
    Discussions |
    Mar 7, 2024 7:58 AM
    1162 views | 1 replies
  • 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

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