cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.

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

  • 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
    985 views | 1 replies
  • Color cells

    Hi,  How I can gray-out empty or with dots cells? I have version 16.1. Thanks

    LargeCanary830 LargeCanary830
    Discussions |
    Nov 2, 2023 6:18 AM
    2157 views | 9 replies
  • Nested Cross-Validation Script?

    Hello, how can I apply nested cross-validation outside of the model screening platform? I would strongly suggest to extend the Make-Validation-Column Section by an option to automate nested cross validation for all predictive models. It would be cool to just select a validation column (or 2 validation columns) for nested cross-validation. In the meantime, could you please provide me with an exampl...

    MarkusJH MarkusJH
    Discussions |
    Nov 2, 2023 3:21 AM
    538 views | 0 replies
  • How to select individual cell based on condition and insert it?

    Hello
    I am trying to select an individual cell based on condition and insert it to a column in JSL.
    For example:I have this following table - I want to insert to the first row under column "value"  the "score" value of the second row (11) because:
    when looking on the first and second row:home = home and y=y and x=x+1Input:scorehomeyxvalue10US11 11US12 10Canada11 10US35  Expected: scorehomeyxvalue10U...

    septon septon
    Discussions |
    Nov 2, 2023 2:59 AM
    641 views | 1 replies
  • How to avoid the query not yielding results when the missing value is null in multi-criteria matching?

    When join tables with more than one matching condition, for example, matching according to USL, LSL and Nominal in two tables, the lookup will be empty when there is only upper limit or only lower limit, i.e., when the lower limit is a missing value or the upper limit is a missing value, how to solve this solution? Are all the missing values replaced with 9999? Thanks!

    lehaofeng lehaofeng
    Discussions |
    Nov 1, 2023 9:19 PM
    1290 views | 4 replies

Latest Discussions

  • 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
    985 views | 1 replies
  • Nested Cross-Validation Script?

    Hello, how can I apply nested cross-validation outside of the model screening platform? I would strongly suggest to extend the Make-Validation-Column Section by an option to automate nested cross validation for all predictive models. It would be cool to just select a validation column (or 2 validation columns) for nested cross-validation. In the meantime, could you please provide me with an exampl...

    MarkusJH MarkusJH
    Discussions |
    Nov 2, 2023 3:21 AM
    538 views | 0 replies
  • How to select individual cell based on condition and insert it?

    Hello
    I am trying to select an individual cell based on condition and insert it to a column in JSL.
    For example:I have this following table - I want to insert to the first row under column "value"  the "score" value of the second row (11) because:
    when looking on the first and second row:home = home and y=y and x=x+1Input:scorehomeyxvalue10US11 11US12 10Canada11 10US35  Expected: scorehomeyxvalue10U...

    septon septon
    Discussions |
    Nov 2, 2023 2:59 AM
    641 views | 1 replies
  • How to avoid the query not yielding results when the missing value is null in multi-criteria matching?

    When join tables with more than one matching condition, for example, matching according to USL, LSL and Nominal in two tables, the lookup will be empty when there is only upper limit or only lower limit, i.e., when the lower limit is a missing value or the upper limit is a missing value, how to solve this solution? Are all the missing values replaced with 9999? Thanks!

    lehaofeng lehaofeng
    Discussions |
    Nov 1, 2023 9:19 PM
    1290 views | 4 replies
  • How to open data files from earlier versions?

    I recently upgraded to JMP Pro 14. Now I can't open most of my older data files (not that old, not back to v. 1, some go back to JMP 5, but most are much more recent). I trashed my older versions of JMP. Is there a way to somehow open older JMP data files and save them in this new version? Thanks for any help.

    whallon whallon
    Discussions |
    Nov 1, 2023 7:58 AM
    3246 views | 4 replies

Latest Discussions

  • Nested Cross-Validation Script?

    Hello, how can I apply nested cross-validation outside of the model screening platform? I would strongly suggest to extend the Make-Validation-Column Section by an option to automate nested cross validation for all predictive models. It would be cool to just select a validation column (or 2 validation columns) for nested cross-validation. In the meantime, could you please provide me with an exampl...

    MarkusJH MarkusJH
    Discussions |
    Nov 2, 2023 3:21 AM
    538 views | 0 replies
  • 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
    518 views | 0 replies
  • How to adjust the factor range for specific factors within an ongoing DOE

    Hi, I designed a DOE that has two independent buffers. This DOE will range components in each buffer which will be used in a processing step sequentially. IE, buffer A, followed by buffer B. We already prepared for the DOE, and formulated the A buffers as per the recommended design. For the B buffers, we intended on ranging 2 components but later decided to reduce to ranging one component, and als...

    MetaLizard62080 MetaLizard62080
    Discussions |
    Oct 26, 2023 5:25 PM
    473 views | 0 replies
  • Type 1 MSA for microscope and Offset.

    Hello Everyone,I was looking for someone who could help me with a dilemma I'm facing with respect to an MSA for a microscope. The specific problem is that i do not have tolerance I can input for my type 1 analysis. Resolution used is 5 microns per pixel, the accuracy cannot be below 5 microns. This is the standard resolution for particles starting from 50 microns. I have attached the Linearity stu...

    MSAanalysis MSAanalysis
    Discussions |
    Oct 23, 2023 12:58 AM
    1030 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
    429 views | 0 replies
view all discussions