JMP User Community

Latest Discussions

Remove rows with one or more empty values using JSL

I have a table where each row contains a single measurement type at three temperatures, each stored in its own column. Ultimately, I want to calculate the deltas between these measurements and then stack that data into a new table. However, not all measurements are taken at all three temperatures, and I need to exclude those measurements (rows) where one or more of the data columns are empty. I ne...
mwyant

Discussions |
Apr 18, 2025 2:41 PM

53169 views | 12 replies
How to add labels to data points in Fit Y by X platform?

Hello, this seemingly easy task has been frustrating. I have a column of labels in addition to my X/Y data points. I want to add a label to each of the data points using the labels column in the 'Fit Y by X' platform, NOT IN GRAPH BUILDER. (The reason is that I want a line fit with the slope forced at 1). I searched but could not find a solution. JMP 18. Any ideas?
TheDude

Discussions |
Apr 18, 2025 10:55 AM

864 views | 2 replies
Fit some models: how can i run and save all fits to the datatable?

in JMP 17: I have completed a dsd with many outputs (over 100 outputs). I can use fit definitive screening to open an interface and enter all the inputs, all the outputs and it proceeds to fit a model for each output. What i want to do now is "Run Model" (for each model) and then "Save script to datatable" (for each fit model). How would i write a script to do this? chatgpt suggests the follow...
rk3

Discussions |
Apr 18, 2025 10:02 AM

1468 views | 3 replies
crop image and store into new column

I wanted to crop images and store the cropped images in a new column.

My first approach was: for each row (:new col = :old col << crop(...)) ... but then I found @Craige_Hales post in the the community,
https://community.jmp.com/t5/Discussions/Crop-a-JPG-Image/m-p/442473/highlight/true#M69072
with the important information:
So, I tried this: Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big C...
hogi

Discussions |
Apr 18, 2025 3:24 AM

1332 views | 3 replies
Searching elements in Tree box

Is it feasible to search for elements in a tree box?
The method shown in the link below searches for user-entered elements in a list box, but this approach does not apply to a tree box.
Searching elements in listbox This is because a list box can easily use a loop to search through all items. What methods can be used to search for elements in a tree box?
The following JSL is an example of creatin...
BabyDoragon

Discussions |
Apr 18, 2025 12:56 AM

3096 views | 15 replies

Previous
Next

Latest Discussions

Fit some models: how can i run and save all fits to the datatable?

in JMP 17: I have completed a dsd with many outputs (over 100 outputs). I can use fit definitive screening to open an interface and enter all the inputs, all the outputs and it proceeds to fit a model for each output. What i want to do now is "Run Model" (for each model) and then "Save script to datatable" (for each fit model). How would i write a script to do this? chatgpt suggests the follow...
rk3

Discussions |
Apr 18, 2025 10:02 AM

1468 views | 3 replies
Is it possible to select multiple options in a tree box by mouse dragging like listbox?

In the tree box, when the Multiselect setting is set to 1, it allows multiple selections of options in the tree box (as shown in the JSL Script). However, unlike the list box, in this case, multiple selections are made while holding down the Ctrl key. Is there a way to select multiple items like in a list box, not only by holding the Ctrl key but also by dragging the left mouse button to select mu...
BabyDoragon

Discussions |
Apr 17, 2025 11:52 PM

478 views | 1 replies
How to query a large data table based on a column level and return columns whose name contains that level?

We want to build a quality monitoring application to deploy across dozens of production facilities (eventually publish to JMP Live). For each facility, we have a very tall & wide data table (let's call it dtBigBoy, <1000 cols, 10k-100k rows) that is refreshed from a process data historian which cannot be queried directly (we get all the data between start/stop timestamps and concatenate the fres...
markschahl

Discussions |
Apr 17, 2025 3:02 AM

1183 views | 5 replies
How do I change the Graph Frame box Outline color and add a box around legend?

Hello!
I am trying to make the top and right border on the attached graph black and size 2 to make it publication quality. I am able to toggle it on and off using Right click -> Graph -> Border though. I checked the properties as well and I am unable to see a option to change it.

Additionally, I want to put a outline around the Legend frame box if possible?
Thanks!
KarthikSuresh

Discussions |
Apr 16, 2025 6:36 AM

757 views | 2 replies
Convert Character Timestamp to Numeric Date

I've read through past discussion posts trying to find a solution to converting a timestamp that is character/nominal into a date that is numeric/ordinal. So far I've tried the following approaches without success: Reimporting the .CSV with numeric/ordinal selectedFormula using informat and formatRecoding Does anyone have a formula suggestion that I can use to transform 'Timestamp' into the format...
Sarah_Gagne

Discussions |
Apr 15, 2025 8:28 AM

856 views | 2 replies

Previous
Next

Latest Discussions

steps to use the minimum p-value approach with log-rank test?

I am interested in applying the minimum p-value approach using the p-values obtained from the log-rank test. However, I am uncertain about the specific steps involved. Could you kindly advise me on how to proceed? I am currently using the following version: JMP® Student Edition 18.2.0, running on Microsoft Windows 11 Home.
Namamugi

Discussions |
Apr 10, 2025 11:22 PM

562 views | 0 replies
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

Discussions |
Feb 28, 2025 11:25 AM

484 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

Discussions |
Feb 27, 2025 2:59 PM

530 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

Discussions |
Feb 18, 2025 1:37 PM

451 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

Discussions |
Feb 18, 2025 7:07 AM

555 views | 0 replies