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

  • Change column format

    Hi all, I am opening a csv file with dates (0000-00-00) having a default column data type character. However, whenever I tried to update the column with a formula from another column with a date value, I cannot change the format into date. My code looks something like thisdt = Open ("C:\Users\table1.jmp"); dt2 = Open ("C:\Users\table1.jmp"); dt2 << Update( With( dt), Match Columns( :idFin = :idF...

    UserID16644 UserID16644
    Discussions |
    Oct 10, 2023 6:06 PM
    1404 views | 1 replies

  • How to create a two column user input modal window where the second column is populated based on single input on first column?

    I would like to create a two column user input modal window where the user input goes into the first column (single input box) for a "parent part ID", based on which adjacent second column window entries (child part IDs) get populated.The entries in the second column come from a database query (for which I already have a script). A "parent part ID" can have one or more than one "child part IDs"Thi...

    Neo Neo
    Discussions |
    Oct 10, 2023 9:10 AM
    8684 views | 21 replies

  • How do replace these with JSL with regex substitution?

    This is copied in the browser. How to use JSL's regular substitution is processed into syntactic JSL with the following requirements:
    1, contains POST......HTTP/1.1 replaced with: u="...";h=[=>];
    2, containing:, write h
    3. The last line..., replace with: jj="...";rs=New HTTP Request(URL(u),Method("POST"),JSON(jj),Headers(h));Thanks! POST https://app.com/w1/api HTTP/1.1 Host: apparticle.longhuvip.com ...

    lala lala
    Discussions |
    Oct 10, 2023 12:02 AM
    4043 views | 11 replies

  • Update column value from another table using wildcard

    Hi all, is it possible to update a column from values coming from another table using wildcard as key? I have this example table but doesn't know how to use wildcards properly in updating tables. Also, I am still using JMP 15 version Table AId_AModelStatusStart DateEnd Date23-ABC-AAADone2023-10-012023-10-0523-ABD-BBBDone2023-10-022023-10-0723-ACD-BBCOngoing2023-10-032023-10-09 Table B (file to be ...

    UserID16644 UserID16644
    Discussions |
    Oct 9, 2023 9:40 PM
    977 views | 2 replies

  • Format List Box text by value that naturally shows up when using the By clause in JSL

    Hi all,  I am trying to make an individual oneway chart based on the value in a given list. I am able to do it in a for loop using where column == value in list and so on. The issue is that when I use a where clause I get this TextBox in the Listbox above the chart that I am unable to change the text of through JSL. I am able to change it when I right click and go into the properties but I want th...

    neelsrejan neelsrejan
    Discussions |
    Oct 9, 2023 8:55 PM
    1303 views | 1 replies

Latest Discussions

  • How do replace these with JSL with regex substitution?

    This is copied in the browser. How to use JSL's regular substitution is processed into syntactic JSL with the following requirements:
    1, contains POST......HTTP/1.1 replaced with: u="...";h=[=>];
    2, containing:, write h
    3. The last line..., replace with: jj="...";rs=New HTTP Request(URL(u),Method("POST"),JSON(jj),Headers(h));Thanks! POST https://app.com/w1/api HTTP/1.1 Host: apparticle.longhuvip.com ...

    lala lala
    Discussions |
    Oct 10, 2023 12:02 AM
    4043 views | 11 replies

  • Update column value from another table using wildcard

    Hi all, is it possible to update a column from values coming from another table using wildcard as key? I have this example table but doesn't know how to use wildcards properly in updating tables. Also, I am still using JMP 15 version Table AId_AModelStatusStart DateEnd Date23-ABC-AAADone2023-10-012023-10-0523-ABD-BBBDone2023-10-022023-10-0723-ACD-BBCOngoing2023-10-032023-10-09 Table B (file to be ...

    UserID16644 UserID16644
    Discussions |
    Oct 9, 2023 9:40 PM
    977 views | 2 replies

  • Syntax error with "function" or "for"

    Hello JMPers, My (JMP 14.3.0, W10) intention is to write a function that takes a table (dt) and list of unique Lot Numbers (uids) as input, and construct a table by concatenating a copy of dt for each uid, and filling in the appropriate Lot. No. information for each of those spots. The purpose of this is so I can later do join operations on the table. I am in the early part of the JSL learning cur...

    ScottMullin ScottMullin
    Discussions |
    Oct 9, 2023 6:51 PM
    2422 views | 1 replies

  • How to run multiple "update from database" table scripts run at once without deleting columns?

    Hello! I have a data table that was produced via a script running two separate queries (that provide data from two different sources) which are then merged to form a data table. My question is with regards to updating this table daily in a way that the script doesn't need to be re-run from the start and any cleaning/adjustments/new columns can be kept. I see on the side bar there is both an "updat...

    Jaiyce_x Jaiyce_x
    Discussions |
    Oct 9, 2023 3:01 PM
    1637 views | 1 replies

  • How to get non-duplicate column names from the "leaf label formula" of decision tree model?

    For example, use the following JSL to get the Leaf Label Formula.Extract the column names from the formula in the first 10 rows.Thanks!d0 = Open( "$SAMPLE_DATA/Equity.jmp" ); p=Partition( Y( :BAD ), X( :LOAN, :MORTDUE, :VALUE, :REASON, :JOB, :YOJ, :DEROG, :DELINQ, :CLAGE, :NINQ, :CLNO, :DEBTINC ), Validation Portion( 0.3 ) ); p<<go;Wait(2); p << save leaf label formula;

    lala lala
    Discussions |
    Oct 7, 2023 8:02 AM
    1503 views | 3 replies

Latest Discussions

  • What determines which data table is seen as "Associated Data" for New Window?

    What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)?   This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...

    jthi jthi
    Discussions |
    Sep 21, 2023 9:44 AM
    871 views | 0 replies

  • Data Access Handler

    How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties.  But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...

    hogi hogi
    Discussions |
    Sep 16, 2023 12:21 AM
    657 views | 0 replies

  • Use JMP Locale Settings( 0 ) not working on macOS

    It seems the following command does not work for JMP MacOS.   Use JMP Locale Settings( 0 )   Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user? // Configuring JMP to save CSV as commas and not If( (Num( "3.14" ) == 3.14), is_EN_num_format = 1, //"English numeric format" is_EN_num_format = 0 //"Non-english"); )...

    FN FN
    Discussions |
    Sep 15, 2023 10:21 AM
    787 views | 0 replies

  • Exporting Graphs from Tab box to Excel cell

    Hi, Is there a way to export the graphs in each tab box in the Excel cells that look something like the one below?JMP Tab Box Excel  Below is the jsl code to create graphsdt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" ); List1 = {"NPN1", "PNP1", "PNP2", "NPN2", "PNP3", "IVP1"}; List2 = {"PNP4", "NPN3", "IVP2", "NPN4", "SIT1"}; List3 = {"INM1", "INM2", "VPM1", "VPM2", "VPM3"}; List4 = {"SN...

    Jackie_ Jackie_
    Discussions |
    Sep 12, 2023 2:09 PM
    824 views | 0 replies

  • PickFile() from within a Project does not use file filters

    When I use PickFile() outside of a project, it works as noted in the scripting guide, scripting index, and other posts here in the forums. However, when I run the script within a project, the window that opens is a different one. It seems to be in order to allow you to pick a file that is saved to the project itself, but the filters do not work even though it shows the folder that I specified as d...

    R2OKeefe R2OKeefe
    Discussions |
    Sep 3, 2023 8:45 PM
    1204 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