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

  • Multiple excel file import, extracting data from specific sheet

    Dear expert JMP users, I have a lot of data files generated by an instrument that I've used - each one is consistent in format but they are all in individual sub-folders and each folder contains other files that are not of interest.Is there a way of writing a script (I'm completely new to JMP scripting) to look in all sub-folders of a given directory, search for excel files ending in ' infos.xlsx'...

    JMPinthePool JMPinthePool
    Discussions |
    Sep 15, 2023 7:46 AM
    3739 views | 4 replies

  • How can use JSL to automatically add code to "Event Handler" in "Properties" of a specified column?

    Big Class.jmpThanks!Function( {thisTable, thisColumn, iRow}, {}, n1rows = thisTable << Get Rows Where( :n1 == thisTable:thisColumn[iRow] ); n2rows = thisTable << Get Rows Where( :n2 == thisTable:thisColumn[iRow] ); thisTable << Select Columns( {thisColumn, :n1, :n2} ) << Clear Cell Colors; thisColumn << Color Cells( {3, {iRow}} ); :n1 << Color Cells( {3, n1rows} ); :n2 << Color Cells( {3, n...

    lala lala
    Discussions |
    Sep 15, 2023 7:33 AM
    1479 views | 2 replies

  • What is the JSL equivalent of Cols>> Column Names>>Move Up ?

    For an open data table, what is the JSL equivalent to Cols>> Column Names>>Move Up ?(cannot see the script in the log when I do this interactively)I need to make the first row of my data table as header (via JSL). I am on JMP 16. 

    Neo Neo
    Discussions |
    Sep 15, 2023 1:50 AM
    2604 views | 5 replies

  • Simpler way to save a new script to data table

    (1) I compose a script in a new script window by 'save to script window' for a number of actions, e.g. filtering, plotting etc. This window is not connected to the data table, yet.(2) To save the script I  go to the data table, open a new script, give it a name, copy paste content from the other script window and then save. Is there a simple way to save the script to the data table without first h...

    Ake Ake
    Discussions |
    Sep 14, 2023 6:15 AM
    1240 views | 1 replies

  • Rename columns contains certain symbol

    Hello dear users/experts, I have a table has many columns, where some of the columns are started with "std" (some are not),for example column names could be:std_A, std_AX, med_XA,data_Ex,std_BN.... And i would like to change to A_std, AX_std, med_XA, data_EX, BN_std... only remove std at the begining of column names and put them in the end with _  

    MarkovRootFox46 MarkovRootFox46
    Discussions |
    Sep 14, 2023 1:40 AM
    933 views | 1 replies

Latest Discussions

  • Multiple excel file import, extracting data from specific sheet

    Dear expert JMP users, I have a lot of data files generated by an instrument that I've used - each one is consistent in format but they are all in individual sub-folders and each folder contains other files that are not of interest.Is there a way of writing a script (I'm completely new to JMP scripting) to look in all sub-folders of a given directory, search for excel files ending in ' infos.xlsx'...

    JMPinthePool JMPinthePool
    Discussions |
    Sep 15, 2023 7:46 AM
    3739 views | 4 replies

  • Simpler way to save a new script to data table

    (1) I compose a script in a new script window by 'save to script window' for a number of actions, e.g. filtering, plotting etc. This window is not connected to the data table, yet.(2) To save the script I  go to the data table, open a new script, give it a name, copy paste content from the other script window and then save. Is there a simple way to save the script to the data table without first h...

    Ake Ake
    Discussions |
    Sep 14, 2023 6:15 AM
    1240 views | 1 replies

  • Rename columns contains certain symbol

    Hello dear users/experts, I have a table has many columns, where some of the columns are started with "std" (some are not),for example column names could be:std_A, std_AX, med_XA,data_Ex,std_BN.... And i would like to change to A_std, AX_std, med_XA, data_EX, BN_std... only remove std at the begining of column names and put them in the end with _  

    MarkovRootFox46 MarkovRootFox46
    Discussions |
    Sep 14, 2023 1:40 AM
    933 views | 1 replies

  • Rerun Transfrom Column

    To reevaluate the Formula of a Formula column, one can writecol<<Eval Formula()Is there a similar command to re-evaluate a Transform Column?

    Eval Formula doesn't seem to work here - Tcol1 still shows a curve with ::scalingFactor=1: Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); gb = dt << graph builder(); ::scalingFactor= 1; tC = dt << transform column ("TCol1",Formula( :heig...

    hogi hogi
    Discussions |
    Sep 13, 2023 4:51 AM
    1677 views | 4 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

Latest Discussions

  • 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

  • Robust Fit Outliers - different row set selected and excluded as outliers

    Dear community,I have a stacked data table, and want to exclude outliers by a Label (e.g. an element for some measurements).In the robust fit outlier platform I can detect outliers and than can select or exclude corresponding rows.For my understanding, rows that are selected than or excluded, should be exactly the same ones.And that is the case for the below sample data table used in the JSL below...

    Georg Georg
    Discussions |
    Aug 16, 2023 2:40 AM
    1001 views | 0 replies

  • Get the JMP Default Dark color theme

    Hello, Is there anyway I could extract all the color codes used in these color themes, using JSL or any another way?I do have difficulties in dealing with colors, hence I rely more on HEX codes, or numeric codes.  Thank you.

    Kenobi Kenobi
    Discussions |
    Aug 9, 2023 9:26 AM
    1299 views | 0 replies

  • How to use JSL of JMP software to find the one that is more suitable for sinusoidal curve from multiple sets of data?

    Hello!For example, using large class data:
    Compare the height column and the weight column to see which column fits the sinusoidal distribution better.
    The parameters of the sine curve are random. Thanks! 

    UersK UersK
    Discussions |
    Jul 24, 2023 11:44 PM
    804 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