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

  • Control Chart Labels

    I recently upgraded to JMP 18 from JMP 14. I much prefer the format of legacy control charts where the UCL and Avg lines are labeled with their values just to the right of the graph. Is there a way to accomplish this with the new control charts, instead of that information being in a separate table? I have a decent knowledge of JMP scripts and used to be able to manipulate these labels in the lega...

    DanFromCA DanFromCA
    Discussions |
    Jun 18, 2024 7:57 AM
    1268 views | 2 replies
  • Get column names that has particular value

    Hi,  I just started using jmp at work and trying to learn JSL. I am trying to write a script to get the column names where the row value =1. For example, the table shows values of 0 and 1 under different IMCX columns and I want to find out which column has the value =1 in each row and store under a new column called IMC. In the first row,  column IMC 4 has 1 so I manually enter IMC4 under IMC. The...

    Paul06 Paul06
    Discussions |
    Jun 18, 2024 7:28 AM
    6281 views | 10 replies
  • How to count number of rows generated by Tabulate()?

    I have a JSL of the form below to generate a table using Tabulate (). How do I count the number of rows in the table?Note the number of rows change with what I have got selected in the Local Data Filter () and the row count needs to be updated with my filter selection.Tabulate( Add Table( Column Table( Grouping Columns( :Parameter1 ) ), Row Table( Grouping Columns( :Wafer ) ) ), Local Data ...

    Neo Neo
    Discussions |
    Jun 18, 2024 4:52 AM
    1512 views | 3 replies
  • How to re-access a file on SharePoint?

    Some time ago I created a script that gets data from a file on SharePoint. Everything worked smoothly. One day I started receiving an access error. I have attached the code but I have removed the exact link.
    How to fix it and where is the cause of the problem?//JMP16
    dt = Open("https://link?download=1", Worksheets( "Sheet name" ), //Sheet selection Use for all sheets( 1 ), Concatenate Worksheets(
    ...

    ControlModes159 ControlModes159
    Discussions |
    Jun 17, 2024 9:48 PM
    1372 views | 1 replies
  • JSL for how to copy and paste columns like you can with right clikcing a column

    Hello everyone,I was scouring the Scripting Index and I couldn't find any refence for how to script in the copy column and paste column options The log will record the past portion but does not record the copy portion.Looks like the paste portion is just creating a new formula with the same name and then pasting over the copied properties from the copied column (I'm trying to copy over multiple sm...

    shampton82 shampton82
    Discussions |
    Jun 17, 2024 11:56 AM
    4477 views | 9 replies

Latest Discussions

  • How to count number of rows generated by Tabulate()?

    I have a JSL of the form below to generate a table using Tabulate (). How do I count the number of rows in the table?Note the number of rows change with what I have got selected in the Local Data Filter () and the row count needs to be updated with my filter selection.Tabulate( Add Table( Column Table( Grouping Columns( :Parameter1 ) ), Row Table( Grouping Columns( :Wafer ) ) ), Local Data ...

    Neo Neo
    Discussions |
    Jun 18, 2024 4:52 AM
    1512 views | 3 replies
  • Reference portion of array/list indirectly

    Using JMP 17.0.0, Windows 10.I've been unsuccessful at finding documentation on what I want to do, and it seems not to be as easy as I thought it would be... What I want is to update a table (dtJ) with columns from another table (dtN), but not define precisely how many columns to add, as the amount of columns to be added may differ each time my For loop runs. For( r = 1, r <= N Items( dtlist ), r+...

    GreenisBTFL GreenisBTFL
    Discussions |
    Jun 17, 2024 10:08 AM
    816 views | 1 replies
  • run table script

    What is the difference between running a Table Script via the green Play icon: ... and via the Run button? 

    hogi hogi
    Discussions |
    Jun 16, 2024 8:24 AM
    5227 views | 12 replies
  • import Multiple excel files with many tabs into one table in JMP

    Hi, I am using "import Multiple files" feature to get data from different excel files, my challenge is that only data from the first tab are extracted. I have three more tabs on each file that I would like to get the data from. Is there a way to do that in JMP? appreciate all the help.AFaiz

    AFaiz AFaiz
    Discussions |
    Jun 13, 2024 4:27 AM
    7828 views | 15 replies
  • Corrupted Power Point Slides.

    Hi all, I'm running into a problem where when I export the data to power point, the power point indicates the slides are corrupted and then the PPT slides closes after that. I can't even get a preview of the data. 

    RA899 RA899
    Discussions |
    Jun 12, 2024 10:54 AM
    1069 views | 1 replies

Latest Discussions

  • How do I make scattorplot Matrix with multiple cloumns I select?

    Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...

    NagneTE1 NagneTE1
    Discussions |
    May 27, 2024 5:18 PM
    784 views | 0 replies
  • graph builder bug - x group shift

     (JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups  are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...

    ShlomiB76 ShlomiB76
    Discussions |
    Apr 14, 2024 12:08 AM
    720 views | 0 replies
  • Project ignoring H Splitter Box Set Sizes . . . sometimes

    I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...

    ionatx ionatx
    Discussions |
    Apr 4, 2024 1:25 PM
    710 views | 0 replies
  • Error during stemming in text explorer: Inconsistent Recodes in access or evaluation of 'List'

    Hello Community! I'm trying to recode the stemming in text explorer based on a fixed dictionary of words and I'm getting this error "Inconsistent Recodes in access or evaluation of List". This is my code: obj = dt << Text Explorer( Text Columns( :col1) ); obj << Stemming("Stem for Combining"); obj << Add Recodes( {{"attractive", "Attract"},{"unattractive", "Attract"},{"attract", "Attract"},{"ugl...

    sm3001 sm3001
    Discussions |
    Mar 21, 2024 12:49 AM
    932 views | 0 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
view all discussions