JMP User Community

Latest Discussions

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

2363 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

1485 views | 4 replies
Random decimals incorporated in mixture screening design

Hi I wonder why JMP introduces the four highlighted numbers (yellow) in the design (0.025064, 0.024936, 0.025089 and 0.024911)? Why are these four values not 0.025?
Principles77

Discussions |
Feb 16, 2024 12:53 AM

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

1349 views | 3 replies
Getting the items of a character column as a list

Hi all, I'm simply trying to get a character column as a list. The column has duplicate entries and I would like a function that returns only the unduplicated rows. I tried using the "Get as matrix" function along with the " as column" function, but I kept getting different errors. Any help is appreciated. Thanks.
RA899

Discussions |
Feb 15, 2024 9:36 PM

1113 views | 2 replies

Previous
Next

Latest Discussions

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

1349 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

430 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

712 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

735 views | 2 replies
Predictor Screening Question

Just a general question - for the Predictor Screening Platform, if you're trying to find variables related to a particular Response Output (say product Yield) - would you ever bring in another response variable & add it to the "X" box - like "impurity" or something along those lines? Or should you only be bringing in explanatory variables in that "X" box?
mjz5448

Discussions |
Feb 15, 2024 12:23 AM

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

430 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

458 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

504 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

512 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

664 views | 0 replies