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

  • 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
  • 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
    2423 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
  • Optimizing a column formula for standardizing time resolved data to 100% rel. at t=0

    I have received the formula I want to discuss almost 3 years ago from @txnelson, never let go of it since and thought about it many times before now, slowly coming somewhat more seriously to grips with scripting. In the meantime, the formula as saved me a lot of time.In the example below, the same formula is added 3 times, each time with a little bit of variation. The issue I want to discuss are t...

    Ressel Ressel
    Discussions |
    Oct 9, 2023 12:02 PM
    2716 views | 6 replies

Latest Discussions

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