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

1007 views | 8 replies
Is this a bug or i am missing someting?

I have a table (here simplified and called “TestBug.jsl” attached ) that is used to generate some random numbers and then make a calculation based on the table variable, let call this my “simulator table” as each time i re-calculate it this would be one simulation that i want to repeat many times. then i have the following script to automate running the same simulation many times with different ...
peri_a

Discussions |
Oct 9, 2025 2:48 AM

493 views | 2 replies
Script only works when run step-by-step

Names Default to Here(1); Query = current data table(); Query_piv = (Data Table( "SO Query" ) << Tabulate( Add Table( Column Table( Grouping Columns( :Year, :Week ), Analysis Columns( :QTY Ordered ) ), Row Table( Grouping Columns( :Item, :Item Description, :Channel, :Product Type ) ) ) )); Query_tab = Query_piv << Make Into Data Table; Query_piv << close window; Col_Start =...
Phil_Nash

Discussions |
Oct 8, 2025 1:06 PM

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

988 views | 1 replies
JSL to suppress "Download Data Completed" notification on HTTP Request

I am using `New HTTP Request` to paginate through a RESTful API. I expect many pages and have a fairly small page size limit, so I've written code to load the pages in chunks. My issue is that this loop requires occasional user interaction due to a pop-up reading "Download data completed.": This doesn't always happen, and I haven't been able to divine why it only sometimes occurs. Even with a con...
Michael_MXAK

Discussions |
Oct 8, 2025 5:52 AM

948 views | 8 replies

Previous
Next

Latest Discussions

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

988 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

688 views | 4 replies
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

311 views | 0 replies
How should elements in a matrix be represented using variables?

How should elements in a matrix be represented using variables? For example, in following JSL, [1 -3] works properly, but [1 a] causes an error. How can this be fixed? Names Default To Here( 1 ); Word( [1 -3], "This is an apple", " " ); a=-3; Word( [1 a], "This is an apple", " " );
BabyDoragon

Discussions |
Oct 7, 2025 2:35 AM

225 views | 1 replies
JSL implementation of merged cell display format similar to the tabulation function. JMP17

When generating reports using JSL, I want to place a table in a new window that resembles the style displayed by the 【Tabulate】 function (where cells with the same column values can be merged). The data for the report comes from a JMP table.

【My Challenges】
JMP17
1. When I use a new window and add a table box, each row displays data, but cells with the same category are not merged. Is there a method ...
DunnRankBudgie8

Discussions |
Sep 29, 2025 1:50 AM

614 views | 2 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

311 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

515 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

552 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

577 views | 0 replies
How to adjust the size of R plot imported with get R graphics(); ?

I'm trying to run R code in JMP to create a plot. I succeeded in importing the plot in png format, but failed to adjust the size of the plot. I can adjust the "plot_from_R" in png format with the set size(); function in jsl, but it is not proportional and distorted. How can I import plot_from_R in the size I want? R Init(); R Submit( "\[ windows(300,100) #it doesn't work plot(function(x) dnorm(...
CountableModel1

Discussions |
Jan 15, 2025 4:01 PM

611 views | 0 replies