JMP User Community

Latest Discussions

find is missing start from column X till ncol()

Hi, I have a table that has thousand of columns. I want to use column matrix to find if across a range of columns is missing. I first identify the starting of the first column number using Loc(). allcol = dt << get column names(string); colname = column ("starting column") << getname; colnumber = (Loc(allcol ,colname))[1]; then I want to find if the columns from colnumber till ncol() is mis...
dadawasozo

Discussions |
Apr 7, 2025 6:34 PM

641 views | 1 replies
Python Code unable to generate output in JSL (JMP 17 Pro)

Hello All, I have a JSL script that creates a Datatable, and I have a python code block within the JSL script which I want to pass the DataTable to make predictions on the DataTable using a trained machine learning model. Before the python code block, the DataTable is accessible and even opens in JMP. However, after the python code block when I try to access the predictions made by the neural ne...
dmanu221993

Discussions |
Apr 7, 2025 8:31 AM

1460 views | 6 replies
Is there a way to perform Cramer von test in JMP?

Hello, Is there a way to perform Cramer von test within JMP? Has anyone tried this?
HotellingSeal96

Discussions |
Apr 6, 2025 3:25 PM

715 views | 1 replies
find continuous empty cells

Hi, is there a way to find continuous empty rows like below? is there any function in JMP that can quickly finding specific number of continuous empty rows? example in picture. in the same column there is multiple rows that is empty but I only interested with the 3 continuous rows that is empty.
dadawasozo

Discussions |
Apr 5, 2025 5:08 AM

849 views | 2 replies
How to return all matched results from Regex?

How can I return all results from a Regex search? I am using JMP 18.1.2. Names Default To Here( 1 ); string = "I am looking for ^this^, ^that^, and sometimes ^those^."; result = Regex( string, "\^([^\n]*?)\^" ); // Only returns first match.
robot

Discussions |
Apr 4, 2025 2:47 PM

1427 views | 5 replies

Previous
Next

Latest Discussions

Python Code unable to generate output in JSL (JMP 17 Pro)

Hello All, I have a JSL script that creates a Datatable, and I have a python code block within the JSL script which I want to pass the DataTable to make predictions on the DataTable using a trained machine learning model. Before the python code block, the DataTable is accessible and even opens in JMP. However, after the python code block when I try to access the predictions made by the neural ne...
dmanu221993

Discussions |
Apr 7, 2025 8:31 AM

1460 views | 6 replies
find continuous empty cells

Hi, is there a way to find continuous empty rows like below? is there any function in JMP that can quickly finding specific number of continuous empty rows? example in picture. in the same column there is multiple rows that is empty but I only interested with the 3 continuous rows that is empty.
dadawasozo

Discussions |
Apr 5, 2025 5:08 AM

849 views | 2 replies
Nested Lists

I have somehow generated a nested list of columns due to them having been initially grouped. I would like to remove the nesting to have a continuous list of columns I can act on. Instead of {{:A, :B, :C}, (:D, :E, :F}}, I would like to get to {:A, :B, :C, :D, :E, :F}
SpannerHead

Discussions |
Apr 3, 2025 8:24 AM

1501 views | 5 replies
Calculations between rows based on conditions

Hey, I'm new to JMP scripting, but somewhat used to python language. I'm trying to achieve the following with my dummy test table below: 1) Cycle through all rows (both before and after the row) and do calculations only on those rows where Cuvette == 11, remaining rows where Cuvette != 11 the "Output" can be set to NA or whatever. 2) The calcuation itself is between two separate rows. In rows w...
PaleoHunter

Discussions |
Apr 2, 2025 6:25 AM

846 views | 3 replies
I/O error after updating to new JMP version (JMP 18 windows)

Hey everyone, I had been running script every day for years and then we updated to JMP 18 and it is no longer working as intended. It pulls data and appends it to a table but it used to let me run it multiple times and keep appending to the same table. Now it is opening a new table each time. Additionally, it will not save the table. It says it is not in write mode and instead of saving it to ...
IslandDelverGo

Discussions |
Mar 31, 2025 6:00 PM

1022 views | 4 replies

Previous
Next

Latest Discussions

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

561 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

585 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

620 views | 0 replies
Exceptions are the utilities Show, Write, and Print ...

from: https://www.jmp.com/support/help/en/18.1/?os=win&source=application#page/jmp/advanced-expressions-macros-and-lists.shtml# If you assign the expression x+y to a, quoting it as an expression with Expr, then whenever a is evaluated, it evaluates the expression using the current values of x and y and returns the result.
Exceptions are the utilities Show, Write, and Print, which do not evaluate e...
hogi

Discussions |
Jan 7, 2025 10:44 PM

612 views | 0 replies
Extract Expr: Issue with scoped variable

This works: Extract Expr(:height << set name( "new" ), :height ); But this one doesn't *):Extract Expr(myDataTable:height << set name( "new" ), myDataTable:height );Fortunately there is this dirty trick of Extract Expr (it automatically resolves every defined variable **) - which allows this workaround:x = Expr( myDataTable:height); Extract Expr(myDataTable:height << set name( "new" ), x ) *) why...
hogi

Discussions |
Jan 7, 2025 11:35 AM

494 views | 0 replies