JMP User Community

Latest Discussions

Filling rows based by iterating on different column entity

I want to assign a value to each row within a category defined in another column using JSL. For example, Module is the Category column and I want to assign this to All rows in within that category in the New column. the new column should be like this
NewToThis

Discussions |
Jul 1, 2025 12:29 PM

636 views | 6 replies
Copy Column Groups From a Parent Table

I'm creating a summary from a parent table. Columns in the parent table are grouped and I want to maintain the grouping in the summary table? I have renamed columns in the summary to match the parent if that helps?
SpannerHead

Discussions |
Jul 1, 2025 12:26 PM

354 views | 3 replies
Can I copy the embedded scripts from one table to another?

If I have a parent table with many scripts embedded. Can I copy those easily to a summary table or transposed table automatically using JSL?
SpannerHead

Discussions |
Jul 1, 2025 10:49 AM

491 views | 4 replies
How do I open excel files with AIP label(Azure information protection)

Hello all, Does someone know any tricks to open MS excel files with AIP label?? Due to our company policy change, all of our excel files have AIP label. Our scripts worked properly before the change, but after the change it does not and pop-up error message during file-opening procedure. We are unable to remove AIP label from the excel files, so I would like to fix this issue....

Thank you for yo...
WakuWakuGoku

Discussions |
Jul 1, 2025 5:25 AM

842 views | 5 replies
Finding Indices Greater Than a Specified Value in a List

As shown in the JSL below, in the case of a Matrix, 'loc' can be used to display indices greater than 5, but it cannot be applied to a List. How should I find the indices greater than a certain value in the case of a List? show(Loc( [5, 7, 3, ., 5] >= 5 )); show(Loc( {5, 7, 3, ., 5} >= 5 )); //Error
BabyDoragon

Discussions |
Jul 1, 2025 4:00 AM

279 views | 1 replies

Previous
Next

Latest Discussions

Copy Column Groups From a Parent Table

I'm creating a summary from a parent table. Columns in the parent table are grouped and I want to maintain the grouping in the summary table? I have renamed columns in the summary to match the parent if that helps?
SpannerHead

Discussions |
Jul 1, 2025 12:26 PM

354 views | 3 replies
Technical Consultation

Optimisation of Formulations1.1 Intelligent algorithm support, calculating the optimal blending ratios of various batches of powder based on target performance ranges (for example, "tensile strength must be stable at 120±5MPa").1.2 Multi-index balancing: Supports simultaneous optimisation of 3-5 key performance parameters, automatically avoiding conflicts between indicators.1.3 Constraint setting:...
ProbitKitten122

Discussions |
Jun 30, 2025 11:27 PM

369 views | 1 replies
Two required y, responses for variability chart

Hi,
I would like to create a variability chart, but only with one column assigned to y, response. Sometimes that does work, sometimes JMP requires two columns to be assigned to y, response.
Below two screen shots that illustrate the situation. Can anyone help why that happens and how to solve it?

JanH4

Discussions |
Jun 30, 2025 8:35 PM

209 views | 1 replies
Creating plots with error bars with "Fit Yby X", "Graph Builder" or other options

Hi,How do I create plots with error bars based on "Fit y by x", Graph builder, other?The question may refer to two ways to achieve the plots:1. The error bars can be derived from explicitly from the data by creating columns of means, upper/lower errors, from which the plots are created, for e.g. time dependent data.2. From the raw data by grouping several variables (columns) from which the means ...
dingodin

Discussions |
Jun 30, 2025 1:23 PM

3887 views | 11 replies
Calculating Z‐value and Effect Size (r) for a Paired Wilcoxon Signed‐Rank Test

We performed a paired Wilcoxon signed-rank test to compare pre- and post-intervention values. Is there a method or add-in available to calculate the r and Z values?
Tos

Discussions |
Jun 30, 2025 6:50 AM

267 views | 0 replies

Previous
Next

Latest Discussions

Calculating Z‐value and Effect Size (r) for a Paired Wilcoxon Signed‐Rank Test

We performed a paired Wilcoxon signed-rank test to compare pre- and post-intervention values. Is there a method or add-in available to calculate the r and Z values?
Tos

Discussions |
Jun 30, 2025 6:50 AM

267 views | 0 replies
File Exchange - end of life in 2025

Important info: File Exchange transitioning to JMP Marketplace
hogi

Discussions |
Jun 26, 2025 9:41 PM

211 views | 0 replies
Remove Crosshair in Profiler

Hello everyone, I am looking for a solution to remove the crosshair in the Prediction Profiler. Any kind of hack would be helpful, like e.g. changing the transparancy.
AnjaW

Discussions |
Jun 18, 2025 5:15 AM

361 views | 0 replies
How to export a model formula to Excel?

I want to be able to take the prediction formula that I got from my multiple linear regression and put it in excel. I have multiple Quantitative and Categorical X variables and some are splined. I have also preformed a BoxCox transformation. What are the steps that I need to do to take the formula that is given and have it working in excel. I have no coding experience but am not against learning a...
DWS

Discussions |
Jun 13, 2025 8:33 AM

391 views | 0 replies
Testing slices in JMP Pro Mixed Model?

Hello, I am doing a 4-way, full factorial ANOVA with one repeated measures factor (time, 3 samplings) and three between-subject factors (species, color, and irrigation; 2 levels of each) using the Mixed Model personality in JMP Pro 18.1.0. I'm using the AR(1) repeated covariance structure, as it provides the best fit based on AICc values. The analysis indicates I have no significant 4- or 3-way in...
JHS

Discussions |
May 7, 2025 7:38 AM

590 views | 0 replies