JMP User Community

Latest Discussions

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

784 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

1347 views | 5 replies
how to output a smoothed line to csv file?

How can a smoothed line be output to a csv file? Is it possible to view the equation used to smooth the line?
chipsaredown

Discussions |
Apr 4, 2025 1:00 PM

468 views | 1 replies
Script to Colour Passing or Failing Cells

Anyone ever generate a script to colour cells that pass dt = Current Data Table(); // Get all numeric columns colList = dt << get column names( numeric, string ); foundCols = ""; // Loop across the columns and generate the test pass/fails Try(For( i = 1, i <= N Items( colList ), i++, spec = Column( dt, colList[i] ) << get property( "Spec Limits" ); //Establish the Notes Value from the Parent...
SpannerHead

Discussions |
Apr 4, 2025 11:44 AM

1101 views | 4 replies
Importing Data from txt file with lines of data every 10th row

New jmp user here. I have a large text file with data on every 10th row starting on line 6. My column headers are on line 4 and I want to use fixed width fields, but it shifts the first 3 headers to the right when I select my own column width.
cschultz32

Discussions |
Apr 4, 2025 11:10 AM

2304 views | 8 replies

Previous
Next

Latest Discussions

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

784 views | 2 replies
how to output a smoothed line to csv file?

How can a smoothed line be output to a csv file? Is it possible to view the equation used to smooth the line?
chipsaredown

Discussions |
Apr 4, 2025 1:00 PM

468 views | 1 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

1410 views | 5 replies
Evaluate a design build using Easy DOE

We used Easy DOE from JMP 17 to generate a 5 factor/3 response design with 4 continuous (2 level) and 1 categorical (2 level) RSM with 36 runs. Q1: Within the 36 runs there are 3 sets of duplicates. Is this a problem? We assume that since JMP designed it = no, but wanted to check for a better explanation. Q2: Is there a way to perform a "Design Evaluation" of the Easy DOE generated design? In the ...
KILROY153

Discussions |
Apr 2, 2025 8:44 AM

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

798 views | 3 replies

Previous
Next

Latest Discussions

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

496 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

534 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

464 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

561 views | 0 replies
Question About F-Tests in GLMMs with Binomial Errors

Hi,
I have a question regarding Generalized Linear Mixed Models (GLMMs) in JMP pro. Most statisticians consider it inappropriate to use F-tests or t-tests to evaluate predictor contributions in GLMs or GLMMs with binomial errors. This is because F- and t-tests are based on sums of squares, which assume normally distributed residual errors.
While using a logit link function helps linearize the relati...
LanaMilana

Discussions |
Jan 17, 2025 2:21 AM

781 views | 0 replies