JMP User Community

Latest Discussions

How to close the correct tables with "On close" when running the same script multiple times?

Hello, I have an add-in outputting a graph with several tables hidden in the background.Upon closing the window I use the "On Close" function to close related data tables, like this: New window() << On close( Close(TableA, nosave); Close(TableB, nosave); ) ; The problem is if I run the script twice, TableA of the first run will be overwritten during the second script execution.I have tri...
rcookie

Discussions |
Feb 16, 2024 8:31 AM

2345 views | 5 replies
Principal component regression

Hello - I have been working with and using PCA in JMP for about four years now. Nothing fancy, but I feel very comfortable with a lot of the functionality. I've been using the PCs as factors for DoE, thinking I was some kinda smartie and came up with a new use case for PCA. Low and behold, I stumble across a Wikipedia page last week on principal component regression. Ha.

Anyway, I have looked and l...
ehchandlerjr

Discussions |
Feb 16, 2024 8:25 AM

3921 views | 9 replies
Definitive Screening Design Questions

I'm looking to construct a definitive screening design and I'm new to this method. I have JMP 16. This study has 6 factors. A few questions to better understand DSD: 1. Is there any way in the DSD platform to tell it I want replicates? The option doesn't show up anywhere. 2. If I just ran each condition in duplicate and pasted in the duplicate runs, would affect the model ?3. What is the need of t...
sanch1

Discussions |
Feb 16, 2024 8:16 AM

2140 views | 2 replies
Predictor screener vs. DOE?

Just curious if predictor screener can be used to ID important variables the way a screening DOE does - so basically allowing you to go straight into optimization? Just curious if/how people combine predictor screener & DOE - if at all, or what recommendations/best practices people have.
mjz5448

Discussions |
Feb 16, 2024 6:27 AM

3474 views | 7 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 |
Feb 16, 2024 6:19 AM

2097 views | 4 replies

Previous
Next

Latest Discussions

Principal component regression

Hello - I have been working with and using PCA in JMP for about four years now. Nothing fancy, but I feel very comfortable with a lot of the functionality. I've been using the PCs as factors for DoE, thinking I was some kinda smartie and came up with a new use case for PCA. Low and behold, I stumble across a Wikipedia page last week on principal component regression. Ha.

Anyway, I have looked and l...
ehchandlerjr

Discussions |
Feb 16, 2024 8:25 AM

3921 views | 9 replies
Combine Date Column and Time Column to "DateTime"

Hi, I imported data from the .xls file. There is a "Date" column and "Time" column. I have to create a new column with Date Time Combine.I used below formula Date MDY( Month( :Date ), Day( :Date ), Year( :Date ) ) + (Hour( :Time ) * 3600 + Minute( :Time ) * 60 + Second( :Time )) Some rows the output is off by roughly 1 minute but some rows are correct. How Can I fixed this?
yanee

Discussions |
Feb 15, 2024 9:42 PM

2016 views | 3 replies
Visualizing 2-way clustering

Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...
ehchandlerjr

Discussions |
Feb 15, 2024 2:53 PM

581 views | 0 replies
Script for multiple data tables/ Workflow

Hi everyone, I am relatively new to JMP and especially to scripting in JSL. I am looking for a way to apply a existing script to all currently open data tables (imported via multiple files import). Even though I researched through the abundance of community threads about this topic, I was not able to piece together a working solution. Okay, so I have the following working JSL code (note: embedded...
Gab_K

Discussions |
Feb 15, 2024 7:30 AM

1030 views | 1 replies
Save data as Excel file and immediately open it on the computer

HelloI would like to save data in an Excel file and open itI have written the command at the end of the scriptI see JMP saved the data as well, but don't open the file in Excelwhat I have missed in JSL? dt_excel = dt_p << Save( "C:\Users\dburmist\Downloads\Bucket.xlsx" );
dt_excel = dt_p << open( "C:\Users\dburmist\Downloads\Bucket.xlsx" );
Dennisbur

Discussions |
Feb 15, 2024 7:23 AM

1030 views | 2 replies

Previous
Next

Latest Discussions

Visualizing 2-way clustering

Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...
ehchandlerjr

Discussions |
Feb 15, 2024 2:53 PM

581 views | 0 replies
Help with JMP formula (IFERROR)

My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success.
UpliftElk866

Discussions |
Feb 13, 2024 12:19 PM

679 views | 0 replies
Scheduled job failed

Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?
shaiv90

Discussions |
Feb 11, 2024 11:09 PM

707 views | 0 replies
PickFile(), Projects and Network Drives

Did you notice that PickFile looks different when it's opened from within a project? More than that - when Pick File is opened from a project, with mydir pointing to a network drive with thousands of files, Jmp will freeze for dozens of seconds:mydir= "\\computername\directory"; Pickfile("select a file" , mydir) So, if you work in a project, to prevent Jmp from freezing, please be sure that your i...
hogi

Discussions |
Feb 9, 2024 3:07 PM

759 views | 0 replies
How might I include a line break (or a second line) in the print header of a PDF generated from a Journal window?

w = New Window("window", <<Journal, hlb = hlistbox() ); w << Set Print Headers( "lineone \!n linetwo", "", "Page &pn; of &pc;" ); w << SavePDF ( "C:\Users\blahblah.pdf");The above script should include a line break in the "left header" so that it has two lines. Instead the resulting PDF just has a non-printing box character between the two words, like this ... and if i copy that text into this wi...
mann

Discussions |
Jan 31, 2024 6:25 AM

939 views | 0 replies