Welcome to the JMP User Community!

Latest Discussions

• Display a File Open Dialog Box for the user to select a Excel file

  I created a SQL script using JMP SQL Builder  New SQL Query( Version( 130 ), Connection( "JMP" ), JMP Tables( ["Limits" => "Source(Open( \!"C:\Jay\JMP\JMP Scripts\Python Scripts\JMP scripts\New folder\New folder\SQL 2\Limits.xlsx\!", Worksheets( \!"Limits\!" ), Use for all sheets( 1 ), Concatenate Worksheets( 0 ), Create Concatenation Column( 0 ), Worksheet Settings( 1, Has Column...

  Jackie_

  Discussions |

  Mar 24, 2020 11:57 AM

  6930 views | 5 replies

• How to Journal platforms in a new window?

  Hi, I have a simple question that I cannot figure out.I have created a simple UI with different ui elements and containvarious platforms (distributions, etc.). I know that to make these static,I need to journal them. All plots are embedded in the new windowwithin different outline, V Line and H line boxes and use differentfilters from the same data table. The new window resides in a jsl script fil...

  AD1

  Discussions |

  Mar 24, 2020 9:21 AM

  2429 views | 2 replies

• Saving a table box window with HTML links as HTML Report

  Hello, In JMP12, I have a scripted table box with hyperlinks that I want to save as an HTML report (or any other type of report that will keep the hyperlinks active). I get an error from JMP while saving the report with no error description in the log except "unknown".   Is there anything I am missing?   See the sample script below:     path = Get Default Directory(); alist = {"a", "b", "c"}; nlis...

  noviJSL

  Discussions |

  Mar 24, 2020 5:22 AM

  3508 views | 3 replies

• TXT file import issue

  Dear JMP users, I am facing a problem while importing a TXT file. I am using the Following jsl instruction:Open("U:\Lib\PRODUCTION\Report_Prod.txt");I had no problem until a couple of weeks when it came that some data were missing. I could not understand why as data were visible in the file when importing the .txt file into Excel.Today, I finally tried to import using "Load Text File" jsl instruct...

  J_Bonnouvrier1

  Discussions |

  Mar 24, 2020 4:55 AM

  6763 views | 5 replies

• How to replace the text in JSL thru User Interface(a dialog window)

  Hi,I've been using SQL in my JSL, and declared 4 variables and set required value.(see below script)What I want is to create a new window as user interface.. when run this JSL, pop up the window first to allow user to input different values for the variables.For example: 1st run JSL, user input: x,y,z,n for the 4 variables, to achieve the effect like below:set @spec = 'x'
  set @opn = 'y'
  set @Loss = ...

  steven_gong

  Discussions |

  Mar 24, 2020 12:15 AM

  2648 views | 3 replies