JMP User Community

Latest Discussions

Window popup for SQL query that gives user feedback on #rows fetched

Working in JMP 18. I'm having a challenge recreating what I thought used to be a feature when pulling data from a database. I am working in a workflow, and the first step is pulling data from one of our internal databases. The JSL was pulled directly from query builder. The desired behavior is that the user runs the step, and while the query runs (it takes a few minutes), a window pops up gi...
Stefan_Moser

Discussions |
Oct 10, 2025 6:37 AM

875 views | 8 replies
Broadcast "Save Transformed" in Distributions platform

From the Distribution platform, I have a Continuous Fit >> Fit SHASH report with 60 analyses in one output. I would like to do a bulk/broadcasted Red Triangle > Save Columns > Save Transformed, which should result in 60 new columns in my data table, each with its own respective SHASHTrans formula. Broadcasting does not seem to work. Is there a good way to accomplish this?
ashwint27

Discussions |
Oct 10, 2025 3:56 AM

299 views | 2 replies
Column switcher and Graph Builder

Hi, I have a number of columns which I have grouped together.In the graph builder I have the X axis constant, but the Y axis should have the column switcher function where we can chose which parameter we want to switch between from the said group of columns. First I tell JSL what columns should be in the group and which column should be my first columncolList = dttable << get column names( continu...
GgGgGg2024

Discussions |
Oct 9, 2025 8:05 AM

3120 views | 12 replies
How to connect SQL database?

Hi Team , Seeking guidance to connect SQL database server . Regards, Ravi
ABGnu771

Discussions |
Oct 9, 2025 7:35 AM

369 views | 3 replies
JMP 18 crushes

Hello, sometimes it happens that JMP 18 crushes and if I have not previously saved my files I loose everything. Is it possible to recover unsaved files? Thank you BR Camilla
camilla1

Discussions |
Oct 9, 2025 5:48 AM

612 views | 4 replies

Previous
Next

Latest Discussions

How to connect SQL database?

Hi Team , Seeking guidance to connect SQL database server . Regards, Ravi
ABGnu771

Discussions |
Oct 9, 2025 7:35 AM

369 views | 3 replies
JMP 18 crushes

Hello, sometimes it happens that JMP 18 crushes and if I have not previously saved my files I loose everything. Is it possible to recover unsaved files? Thank you BR Camilla
camilla1

Discussions |
Oct 9, 2025 5:48 AM

612 views | 4 replies
Seek the probability of achieving the maximum and minimum pass rates

I have a set of data with already determined results. I want to use the known determination conclusions to infer what combinations of AB data_before can achieve the highest and lowest probabilities of passing the test.
wenwenzhou

Discussions |
Oct 9, 2025 1:40 AM

287 views | 1 replies
Open files from same directory for Workflow

Hello Community, I only just recently started working with JMP Workflows and JSL Scripts and was wondering to create something in code to achieve the following: - The goal is to move a workflow (copy/paste) to a specific folder, where other files like .xlsx and .csv are located. The designed script should then open a specific .csv file from within the same folder the script or workflow is located ...
Gab_K

Discussions |
Oct 8, 2025 10:19 AM

957 views | 1 replies
Col score & Col N unique

Add dense ranking to Ranking Tie and Col Rank functions Col N Categories (:green_heart:) new in JMP19 : New in Graph Builder for JMP 19 very helpful : )

Details you should be aware of: 1) excluded rows are not included in the calculation
[ very useful, along the idea of Formula Editor: meaningful results with excluded rows , nevertheless: somewhat inconsistent, in view of the behavior ...
hogi

Discussions |
Oct 8, 2025 4:00 AM

597 views | 4 replies

Previous
Next

Latest Discussions

Workarounds

very simple tasks - JMP says NO. TaskJMP saysworkaroundswishimplementedadd column via Tables/Updatecolumn existsrename one of the columnsAllow Update platform to create new columns if they already exist in the table to be updatedv19copy a cellformula column- recode to dummy column | copy cell | delete dummy column
- screenshot | OCREdit Pane allows for text copy even if no edit ...
hogi

Discussions |
Oct 7, 2025 3:51 PM

299 views | 0 replies
Confidence level change in reliability growth analysis

When conducting Reliability Growth analysis in JMP (version 18), the confidence level is defaulted as 95%. How can I change it to other level, e.g., 80%? Thanks.
MXJ

Discussions |
Oct 6, 2025 1:16 PM

189 views | 0 replies
Time varying effect in Recurrence Analysis, data format and calculation

Dear all
I am assigned a task to perform recurrence analysis on our data.
The data we have are robot repairs. We want to see repair events and cost in response to accumulated transactions using recurrence analysis.
I attached a simulated data for this question. It only has three bots since we haven't decided how to arrange the data and I just put those three bots manually. I will update with more ...
Caozheng0115

Discussions |
Sep 26, 2025 11:29 AM

820 views | 0 replies
lamda used in final lasso fit with K fold validation

Can someone help me know which lambda was used in the K-fold cross validation of a lasso regression? I see the values listed in the solution path summary table, but unsure which one it uses finally. Perhaps I am missing a main point in the process.... and it is not important
daniel_s

Discussions |
Sep 22, 2025 6:03 PM

381 views | 0 replies
Copy Formula for Tables / Update

In Tables / subset, the user can decide if a column formula is copied and if the evaluation is suppressed: Is there a hidden option which does the same trick for Tables/Update?

great for "documentation"great for "what if" ...on the other hand: one cannot guarantee that all input columns for the formula will be available in the target data table.
-> default option "suppress formula evaluation"?
hogi

Discussions |
Sep 12, 2025 7:47 AM

890 views | 0 replies