JMP User Community

Latest Discussions

get rows in between characters from a column then move other column value (selected row only) to other column

Hi, I want to move or copy paste multiple column value of selected rows to other columns in the same table like picture below the interested rows are always start from :Item == "start" until :Item == "values", but the total rows can be different. I want to copy paste or move value in Col1 and Col2 of the interested rows to Col 3 and Col 4. My current thought is to manually create a list that inc...
dadawasozo

Discussions |
Apr 8, 2025 10:54 AM

1254 views | 4 replies
How to get the path to the current project file?

If I have a script within a project (or perhaps a reference to the project in a script outside of the project), how to do I get the file path to where the project is saved on disk? I'm interested in doing this with JSL, not interactively.
austinspencer

Discussions |
Apr 8, 2025 6:53 AM

7608 views | 14 replies
How to get value of duplicate columns?

Hi all, How can I get the value of a Column A and place it with the duplicate value in Column B? For example, this is my data: Column AColumn BAApple AppleBBanana MangoCMango This is the expected output: Column AColumn BAAppleAAppleBBananaCMangoCMango
UserID16644

Discussions |
Apr 8, 2025 5:46 AM

702 views | 2 replies
How to model responses when their sum is equal to 1?

Hello!

I have completed a DoE in order to model the particle size distribution. The distribution is measured by several screens. For each size range (e.g. <1mm, 1-5 mm, >5 mm), I have the proportion of particles, and the sum must be one. My question is how to model the three responses properly, taking into account that the sum of the responses must equal 1. I have included a synthetic table to...
Florent_M

Discussions |
Apr 8, 2025 5:45 AM

975 views | 3 replies
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

599 views | 1 replies

Previous
Next

Latest Discussions

How to get value of duplicate columns?

Hi all, How can I get the value of a Column A and place it with the duplicate value in Column B? For example, this is my data: Column AColumn BAApple AppleBBanana MangoCMango This is the expected output: Column AColumn BAAppleAAppleBBananaCMangoCMango
UserID16644

Discussions |
Apr 8, 2025 5:46 AM

702 views | 2 replies
How to model responses when their sum is equal to 1?

Hello!

I have completed a DoE in order to model the particle size distribution. The distribution is measured by several screens. For each size range (e.g. <1mm, 1-5 mm, >5 mm), I have the proportion of particles, and the sum must be one. My question is how to model the three responses properly, taking into account that the sum of the responses must equal 1. I have included a synthetic table to...
Florent_M

Discussions |
Apr 8, 2025 5:45 AM

975 views | 3 replies
Life distribution: how to set the markers and weibull fit to use Kaplan-Meier or Turnbull estimates

Hello, The below is the test table I made. According to the description: https://www.jmp.com/support/help/en/18.1/index.shtml#page/jmp/event-plot.shtml#ww1386833 It meas there are total 100 samples. And exactly at 4 readings: 50, 100, 150 and 200, there are 25 new failures happened. So the failure rate I expected will be: 50, 25% 100, 50%, 150, 75% 200,100%. The markers in the Weibull plot ...
Doraemon214

Discussions |
Apr 7, 2025 3:16 PM

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

1377 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

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

493 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

533 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

460 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

560 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

776 views | 0 replies