JMP User Community

Latest Discussions

How do I avoid an error when selecting a row from a filtered table box?

I am running JMP 17.1 and have the script shown below which works thanks to @jthi help. When I run the script, I get a table box of Big Class.jmp in a window and I can select a row and it returns the values of Height and Weight from the selected row. In my real world application, I have a much larger table that I'd like to filter down by right-clicking in the window and choosing "Filter Where......
tbidwell

Discussions |
Nov 2, 2023 8:00 AM

5273 views | 5 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

Discussions |
Nov 2, 2023 7:00 AM

1501 views | 1 replies
Color cells

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

Discussions |
Nov 2, 2023 6:18 AM

3635 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

Discussions |
Nov 2, 2023 3:21 AM

863 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

Discussions |
Nov 2, 2023 2:59 AM

1042 views | 1 replies

Previous
Next

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

Discussions |
Nov 2, 2023 7:00 AM

1501 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

Discussions |
Nov 2, 2023 3:21 AM

863 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

Discussions |
Nov 2, 2023 2:59 AM

1042 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

Discussions |
Nov 1, 2023 9:19 PM

2150 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

Discussions |
Nov 1, 2023 7:58 AM

4142 views | 4 replies

Previous
Next

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

Discussions |
Nov 2, 2023 3:21 AM

863 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

Discussions |
Oct 28, 2023 12:33 PM

799 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

Discussions |
Oct 26, 2023 5:25 PM

760 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

Discussions |
Oct 23, 2023 12:58 AM

1619 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

Discussions |
Oct 19, 2023 11:01 PM

677 views | 0 replies