JMP User Community

Latest Discussions

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

2101 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

1345 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

2018 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

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

583 views | 0 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

2018 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

583 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

1033 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

1035 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

1084 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

583 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

681 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

944 views | 0 replies