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

  • Format Date Time yyyymmdd_hhmmss

    Greetings, I am having an issue with a date-time format when save a csv file.
    The filename should be like "Summary_20231103_082637".

    formattedDate = Format(Today(), "yyyymmdd_hhmmss");
    filename = Convert File Path("C:\Path\Summary_" || formattedDate || ".xlsx", absolute );
    if(File Exists (filename),
    dt << Save (filename, Mode("Append")),
    dt << Save (filename));

    I tried to format the datetime with

    formatDa...

    Celine1 Celine1
    Discussions |
    Nov 3, 2023 3:43 AM
    2233 views | 1 replies

  • Automate concatenating data tables based on name

    Hi, I want to concatenate data tables based on their name.For example I have 6 Data tables, and their names will be something like M1a M1b M2a M2b M3a M3b. So I want to join all M1 devices together etc. However, the M1 part will vary by name so I need the script to be able to get name and then compare part of the name. Any help to get started is very appreciated

    MedianRooster10 MedianRooster10
    Discussions |
    Nov 3, 2023 2:17 AM
    2690 views | 6 replies

  • How to elegantly perform an update, but for a single row?

    Hello - I'm trying to take a row from one table, and throw it into another table at a row the user specifies in an entry box. However, the update function doesn't seem to have the ability to specify rows, and so I'm left with taking an hour and typing out each of my 105 columns for both data tables as such: dt:{"ColA"}[rownumber] = dt1:{"ColA"}[1];
    dt:{"ColB"}[rownumber] = dt1:{"ColB"}[1];
    .
    .
    .
    dt:{"C    ...

    ehchandlerjr ehchandlerjr
    Discussions |
    Nov 3, 2023 1:52 AM
    1412 views | 2 replies

  • Grouped Interpolate

    While writing the post
    https://community.jmp.com/t5/Discussions/Difference-of-lines/m-p/691643/highlight/true#M87740 I was reminded of a question that a colleague of mine had some while ago: Is there a grouped Interpolate function in JSL?Interpolate(myheight, :height, :weight, by(:sex), for({"F","M"}))which returns {weightF, weightM} @ myheight for F & M after separately interpolating :weight vs. :...

    hogi hogi
    Discussions |
    Nov 2, 2023 1:23 PM
    1556 views | 2 replies

  • When a JSL code block crashes, is it possible to post a dialog box with a simple message?

    Hello,I am trying to run a python script using JMP's Run Porgram to read a zipped file and parse the data. Occationally the Zip file has issues and python would through out an error message that " File is not a zip file" Here is the JSL code blockrp = Run Program( executable( python_executable ), Options( {path_python_file, path_working_folder, path_datalog} ), readfunction( "text" ) ); When I exe...

    shafi-arifuzzam shafi-arifuzzam
    Discussions |
    Nov 2, 2023 10:48 AM
    912 views | 1 replies

Latest Discussions

  • How to elegantly perform an update, but for a single row?

    Hello - I'm trying to take a row from one table, and throw it into another table at a row the user specifies in an entry box. However, the update function doesn't seem to have the ability to specify rows, and so I'm left with taking an hour and typing out each of my 105 columns for both data tables as such: dt:{"ColA"}[rownumber] = dt1:{"ColA"}[1];
    dt:{"ColB"}[rownumber] = dt1:{"ColB"}[1];
    .
    .
    .
    dt:{"C    ...

    ehchandlerjr ehchandlerjr
    Discussions |
    Nov 3, 2023 1:52 AM
    1412 views | 2 replies

  • Grouped Interpolate

    While writing the post
    https://community.jmp.com/t5/Discussions/Difference-of-lines/m-p/691643/highlight/true#M87740 I was reminded of a question that a colleague of mine had some while ago: Is there a grouped Interpolate function in JSL?Interpolate(myheight, :height, :weight, by(:sex), for({"F","M"}))which returns {weightF, weightM} @ myheight for F & M after separately interpolating :weight vs. :...

    hogi hogi
    Discussions |
    Nov 2, 2023 1:23 PM
    1556 views | 2 replies

  • When a JSL code block crashes, is it possible to post a dialog box with a simple message?

    Hello,I am trying to run a python script using JMP's Run Porgram to read a zipped file and parse the data. Occationally the Zip file has issues and python would through out an error message that " File is not a zip file" Here is the JSL code blockrp = Run Program( executable( python_executable ), Options( {path_python_file, path_working_folder, path_datalog} ), readfunction( "text" ) ); When I exe...

    shafi-arifuzzam shafi-arifuzzam
    Discussions |
    Nov 2, 2023 10:48 AM
    912 views | 1 replies

  • Aligning graphs from graph builder horizontally in journal - JMP17

    Hi I am looking to have graphs from graph builder side by side in a journal. Currently graphs are vertically arranged in journal. Below is my script: new = new window("final", << journal, vb = V List Box( ob = Outline Box( "OWL vs KESTREL_RX_SENSITIVITY", outline box(" QFN BAND 0") ); ) ); dt1_band0 = open("C:\Users\NXF90574\Documents\NXP\VIshal\OWL_Kestrel_...

    vharibal vharibal
    Discussions |
    Nov 2, 2023 9:21 AM
    2025 views | 3 replies

  • Date imported from Excel in 1904

    Hello Community!  I am trying to do a script to automatically import an Excel file and create some graphs. I have a file with a column of date (dd Mon yyyy) which is important as it will be my X axis (Excel file attached).If I go directly from the Excel file to JMP using the add-on button, it’s working perfectly well, I get my datatable with my Date column properly formatted. But I want to script ...

    Elofar1 Elofar1
    Discussions |
    Nov 2, 2023 7:00 AM
    1507 views | 1 replies

Latest Discussions

  • Functional data in rows-as-functions, but different rows have different step size

    Hello - I have a table with 250+ experiments and thousands of columns, about 100 that are for either raw or transformed data, and then I'm taking output from an xml file with functionally "spectral data" (XRD diffractograms for anyone that is familliar), and just laying that on its side in row form (more explanation if needed in another question I posted here: https://community.jmp.com/t5/Discussi...

    ehchandlerjr ehchandlerjr
    Discussions |
    Oct 28, 2023 12:33 PM
    799 views | 0 replies

  • Is it possible to customize such buttons in the toolbar: a button next to an editor bar?

    The edit bar can fill in characters, click the button to run a JSL, JSL can automatically read the content of the edit bar and write into the variable. Thanks!

    lala lala
    Discussions |
    Oct 19, 2023 11:01 PM
    677 views | 0 replies

  • Is it possible to have independent x-axis ordering within x-axis groups in graph builder?

    In the attached data table the saved script plots the chart below.I want the x-axis parameter bars to change in order with the highest number of fails appearing first within each week (i.e. a Pareto type plot within each week)I created a FailOrder column for ordering within each week, but it does not seem to do what I want. Is there a way, via JSL, to have the order of the parameters (Para) in asc...

    Neo Neo
    Discussions |
    Oct 17, 2023 7:33 AM
    806 views | 0 replies

  • 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
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