JMP User Community

Latest Discussions

Reordering the Factors and Response in the Contour Profiler

When generating a Contour Profiler for a large number of Factors and Responses, I'd like to set the order of Factors and Responses as they appear in the Contour Profiler window. Is this possible through scripting or otherwise?
mpavilonis

Discussions |
Feb 16, 2024 5:45 PM

2472 views | 4 replies
Scripting "make into combined data table" of Fit Life By X with multiple groups

I am trying to build a generic script for Fit Life By X and make into combined data table", as follows:flx = Fit Life by X( Distribution( Weibull ), Nested Model Tests( Location and Scale ), Y( :Name("Left"), :Name("Right") ), X( :d ), By(:Name ,:Location,:Street,:Apt,:Number), <<Fit Weibull, Use Transformation Scale( 0 ), Show Overlay by Levels( 1 ), <<Set Scale( Weibull, Simultaneous ),...
FrequencyBison9

Discussions |
Feb 16, 2024 4:56 PM

1754 views | 3 replies
Determine best fit and re-organize boxes and tables

Hi, Is there a jsl way to identify the best fit for a particular parameter, generate capability analysis tables only for that model fit and then re-organize the display boxes only for the best fit in a new window (pictured below)? Also, can I maintain the functions?

Here is what I tried: It works to an extend....

Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" );...
Jackie_

Discussions |
Feb 16, 2024 11:35 AM

1035 views | 1 replies
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

2790 views | 5 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

2495 views | 3 replies

Previous
Next

Latest Discussions

Scripting "make into combined data table" of Fit Life By X with multiple groups

I am trying to build a generic script for Fit Life By X and make into combined data table", as follows:flx = Fit Life by X( Distribution( Weibull ), Nested Model Tests( Location and Scale ), Y( :Name("Left"), :Name("Right") ), X( :d ), By(:Name ,:Location,:Street,:Apt,:Number), <<Fit Weibull, Use Transformation Scale( 0 ), Show Overlay by Levels( 1 ), <<Set Scale( Weibull, Simultaneous ),...
FrequencyBison9

Discussions |
Feb 16, 2024 4:56 PM

1754 views | 3 replies
Determine best fit and re-organize boxes and tables

Hi, Is there a jsl way to identify the best fit for a particular parameter, generate capability analysis tables only for that model fit and then re-organize the display boxes only for the best fit in a new window (pictured below)? Also, can I maintain the functions?

Here is what I tried: It works to an extend....

Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" );...
Jackie_

Discussions |
Feb 16, 2024 11:35 AM

1035 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

2495 views | 3 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

1216 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

1219 views | 2 replies

Previous
Next

Latest Discussions

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

832 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

886 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

1092 views | 0 replies
GraphBuilder Legend hook

There are many useful instances of being able to have a hook onto the selection state change of a legend for a chart / graph. With the non graph-builder method of generating charts' and graphs' legends (using Row Legend()), this was quite simple as the display element was simply a Table Box() that can receive a Set Row Change Function() message. The same cannot be done (to my knowledge) with Gra...
ErraticAttack

Discussions |
Jan 17, 2024 6:41 PM

747 views | 0 replies
Copy Columns - selected rows

Copy Columns from the right-click context menu of a column header is very useful. Just copy the column(s) - with all the settings ... and paste it into a JSL script - or another table. There is a hidden feature:
When rows are selected, the values of the selected rows are used as arguments of the Set Values() command and will populate the cells of the new column. So, when you select all rows before...
hogi

Discussions |
Jan 3, 2024 1:27 PM

1226 views | 0 replies