JMP User Community

Latest Discussions

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

1040 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

2801 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

2502 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

2075 views | 2 replies
Data Table Box with local data filter

Bug, or user error?If I create a Data Table Box using the following code:Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); nw = New Window( "Demo Data Table Box", Data Filter Context Box( H List Box( dt << Data Filter( //Show Controls( 0 ), Local, //Add Filter( columns( :sex ) ) ), dtb = data Table Box( dt ) ) ) );then manually select 'sex' as the f...
matth1

Discussions |
Feb 15, 2024 11:25 AM

1819 views | 2 replies

Previous
Next

Latest Discussions

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

1040 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

2502 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

1217 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

1225 views | 2 replies
How to supress script dump in log upon closing a chart?

Upon closing a chart the chart plotting script is reproduced in the embedded log of my JSL script (which is used to plot the chart). Any way to supress this?
Neo

Discussions |
Feb 14, 2024 10:08 PM

3238 views | 6 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

1228 views | 0 replies