cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • Categorise Columns by initials

    I'm trying to list available categories of columns based on the first 3 letters of the column title.  I can list all the available values readily but I have many duplicates.  Summarize doesn't obviously work for anything but a list of columns and what I have is a list of initials.  I tried this with no luck.  Any help appreciated. dt = Current Data Table(); dt << Clear Column Selection(); colList...

    SpannerHead SpannerHead
    Discussions |
    Mar 17, 2025 8:25 AM
    632 views | 2 replies
  • Set column formula dynamically with JSL

    I'm working on a JSL script where I need to dynamically build a formula for a given column inside a loop. The idea is to reference a different column for each iteration, so that the formula uses the evaluated column name (e.g., :col_name) rather than inserting the literal code. Here's a simplified version of what I'm trying to achieve in the loop (I have tried many variations of Expr, Eval, Parse ...

    CSkjodt CSkjodt
    Discussions |
    Mar 17, 2025 7:49 AM
    968 views | 3 replies
  • Stack side by side tables from excel and add header columns

    I have been struggling for 2 days pulling data from excel into JMP in the correct format. I have hundreds of excel sheets, but the data is disorganised. There are many tables next to eachother (hundreds) in an excel sheet.I want to stack the data across the different tables, but also make new columns with the associated header data. I have only been able to achieve this on one table, but can't rep...

    LK2 LK2
    Discussions |
    Mar 17, 2025 6:21 AM
    1346 views | 5 replies
  • Questions about the use of JSL encryption.

    Consult the experts.
    I want to design a JSL encryption method:
    I this "original.JSL" is encrypted and used by others A.But I don't want him to give it to someone else.
    What's a good way to do script encryption this way?

    lala lala
    Discussions |
    Mar 17, 2025 5:28 AM
    926 views | 5 replies
  • How to set a limit on the number of options displayed in the Column Switcher, with the rest accessible via scrolling?

    When the alternatives for the column switcher are too long, it elongates the length of the graph. How can we set the column switcher to initially display fewer options, showing a maximum of only 5 items? Users can then scroll down to find more options if they want. As shown in the example below, displaying too many options at once stretches the entire chart.dt = Open( "$SAMPLE_DATA/Employee Master...

    BabyDoragon BabyDoragon
    Discussions |
    Mar 17, 2025 12:54 AM
    554 views | 1 replies

Latest Discussions

  • Questions about the use of JSL encryption.

    Consult the experts.
    I want to design a JSL encryption method:
    I this "original.JSL" is encrypted and used by others A.But I don't want him to give it to someone else.
    What's a good way to do script encryption this way?

    lala lala
    Discussions |
    Mar 17, 2025 5:28 AM
    926 views | 5 replies
  • How do I get Formula of calculate quantile spec limits in process capability

    I do distributions analysis in jmp pro.18 with fit smooth curve function, then get USL/LSL value by using 6-sigma to calculate quantile spec limits under process capability function. I'd like to know what formula is used to calculate USL/LSL. I'm trying to run the same formula in the excel version.  

    Sandra233 Sandra233
    Discussions |
    Mar 17, 2025 12:16 AM
    389 views | 1 replies
  • Set Page Setup for PDF not working as expected

    Hello all, I am running the following code to try and adjust the Page Setup settings for this PDF before exporting it to my desktop. An example of my code looks like this:Names Default to Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); nw = New Window ("Charts", obj = dt << Control Chart Builder( Variables( Y( :height, :weight ) ), Show Control Panel( 0 ), SendToReport( ) ); ); nw <<...

    DerekMoore DerekMoore
    Discussions |
    Mar 16, 2025 3:10 AM
    2025 views | 6 replies
  • Need Help on JSL Scripting to Split Column Data with delimiter, and match with another Column delimiter Split Data

    Hello guys i'm using JMP17 and really need help on JSL script to process the input data below to the desired output data  Input Data Table: | Data|  Label | ID ||----------|----------|----------|| 1_1_64_5_2   | D1_DD4_FF1_FIN1_GPES2   | Apple1   || 1_1_2  | D2_D3_D4   | Apple1   || 1_2_68_5_6   | D1_DD4_FF1_FIN1_GPES2   | Orange1   || 1_2_2  | D2_D3_D4   | Orange1   || 2_1_50_3_10   | D1_DD4_FF1_...

    CohortOpossum40 CohortOpossum40
    Discussions |
    Mar 16, 2025 2:07 AM
    764 views | 4 replies
  • Rename File() and Copy File() both return 0

    Hi, I have a need to save a small data table as a csv but with an alternate file extension (*.blkl rather than *.csv). The Save As() function doesn't seem to allow for such a provision as near as I can tell so instead of saving the file with my desired filename I save it as *.blkl.csv and then attempt to either directly rename that file to the desired name or perform a copy+delete sequence to get ...

    TheSource TheSource
    Discussions |
    Mar 14, 2025 11:43 PM
    759 views | 4 replies

Latest Discussions

  • Discovery summit book signings - official list of books?

    Fellow JMP enthusiasts! During the 2024 Manchester Discovery Summit I was surprised to learn that the handing out and signing of books is a tradition. So, I am wondering whether there is a list of the books handed out & signed so far. If it exists, where to find it?I thoroughly enjoyed reading "Bitch" by Lucy Cooke, and I have a feeling "Hello World" by Hannah Frey will be a good read too.

    Ressel Ressel
    Discussions |
    Feb 28, 2025 11:25 AM
    394 views | 0 replies
  • Inquiry Regarding the Use of JMP and JMP Live (Suppress Eval?)

    Hello, I am a user of JMP Live.
    I am currently utilizing a simple function within JMP to leverage the Auto Refresh feature in JMP Live for dashboard purposes. However, while the function operates correctly on my PC, it does not work properly on JMP Live.Even though I have disabled "Suppress Eval" before executing Data Publish, when I later download the data, the column where the function should be ...

    DJ_Kim DJ_Kim
    Discussions |
    Feb 27, 2025 2:59 PM
    408 views | 0 replies
  • query text files from zip folder in Azure blob file system secure (ABSS) url

    Hi All,I wonder if anyone has the experience to query text files from zip folder through Azure blob file system secure (ABSS) url?
    the url looks like format below. If you do, can you share some script lines how to connect to the url at least?

    abfss://filesystemname@accountname.dfs.core.windows.net 

    dadawasozo dadawasozo
    Discussions |
    Feb 18, 2025 1:37 PM
    350 views | 0 replies
  • Streamlining Data Workflows With JMP & MATLAB

    Integrating tools like JMP and MATLAB offers a streamlined approach to engineering analysis, making workflows more efficient and reducing the need for redundant script rewriting. By leveraging JMP’s powerful data analysis and visualization capabilities alongside MATLAB’s robust computational tools, engineers can seamlessly combine the strengths of both platforms. This integration allows for the ra...

    brycerjs8 brycerjs8
    Discussions |
    Feb 18, 2025 7:07 AM
    431 views | 0 replies
  • Question About F-Tests in GLMMs with Binomial Errors

    Hi,
    I have a question regarding Generalized Linear Mixed Models (GLMMs) in JMP pro. Most statisticians consider it inappropriate to use F-tests or t-tests to evaluate predictor contributions in GLMs or GLMMs with binomial errors. This is because F- and t-tests are based on sums of squares, which assume normally distributed residual errors.
    While using a logit link function helps linearize the relati...

    LanaMilana LanaMilana
    Discussions |
    Jan 17, 2025 2:21 AM
    671 views | 0 replies
view all discussions