JMP User Community

Latest Discussions

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

1224 views | 2 replies
Application Builder - Graph Builder Interface

Hello,I am new to jmp platform and scripting. In application builder interface, when a button is clicked i want to open the graph builder inferface with loaded data columns (same interface as in Analysis - Graph Builder) where user can create graph needed then import the graph into the app screen. i want to incroprate all the intractive features of Graph Builder interface (from selecting graph ty...
ComplexNerd

Discussions |
Feb 15, 2024 1:52 AM

1665 views | 3 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
IF/Else formula - how to return a blank cell

I am creating an conditional formula. If the condition I am evaluating is false, How do I return a blank cell?If( :Orientation == "X", :"X Ave"n / 100, ??)I want to evaluate a column and if it is "X" then I want to perform an equation. If it is any other value I want to return a blank cell.What do use in the "else" part of the formula to return a blank cell?
JSledz289

Discussions |
Feb 14, 2024 12:26 PM

2365 views | 3 replies
How to rename a "New Formula Column"

Hey everyone,I am trying to rename a " New Formula Column" that can have different amounts of columns that get summarized, the default column name out is always changing. However, I can't find a way to reference the column as when the column is made it is not selected. The code to combine the columns is this:dt3 << New Formula Column( Operation( Category("combine"), "Sum" ), Columns(collistm...
shampton82

Discussions |
Feb 14, 2024 11:57 AM

1309 views | 2 replies

Previous
Next

Latest Discussions

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

1224 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
How to prevent Milliseconds from disappearing during Import Data from Database?

Hello, TLDR: Is there a way to keep milliseconds when data is imported from a database? Import JSON, timestamp milliseconds all turn into 0's. JMP 16.2/17.0 I currently have a JSL script that pulls json data from a database ex -> Data Table(open database(dsn_string, sql_string, table_name, Invisible(1))); This script has been working with no issues except that the granularity of the timestamp c...
Glo_Roh

Discussions |
Feb 13, 2024 4:26 AM

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

832 views | 0 replies
I'm Confused About Variables

I'm having a conceptual problem figuring out how local variables work. I'll simplify the issue to focus in on what is confusing to me. I create a local variable, say t0, with a value of 5. Then I write a column formula to increment this value by 1... either t0=t0+1 or t0+=1 (it doesn't seem to matter), the result that I expected was that when JMP evaluated each cell in the column, it would increme...
scott1588

Discussions |
Feb 10, 2024 11:21 AM

3519 views | 4 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

1227 views | 0 replies