Welcome to the JMP User Community!

Latest Discussions

• using a variable as column name when creating a plot

    The script below loads some data and should create twice the same plot.
The first one by referring to the column name by using a variable (test1), the second one by calling the column name directly. 
  The second one works fine, but for the first one I get an empty plot area. I guess there is a problem with how I define or call test1. I have tried different approaches, but so far nothing worked. Nam...

  matthias_bruchh

  Discussions |

  Dec 12, 2025 10:13 AM

  199 views | 2 replies

• JSL Implementation for Deleting Columns with All Missing Values by Same Category

  In the attached file, the field "Store" is divided into two stores, A and B. If all cells in the entire column corresponding to the same Store are missing values, then delete the entire column, as shown in the attached "Expected result". How can this be implemented using JSL?   I am able to count the missing values in each column, but I cannot find a way to verify if all the cells corresponding t...

  BabyDoragon

  Discussions |

  Dec 12, 2025 6:05 AM

  163 views | 3 replies

• How to trigger a user selection for files when creating an automated workflow?

  I'm attempting a fully automated analysis workflow and have been successful except for one step. When I'm recording and select a file from a file folder to analyze, the workflow records to pull that exact file each time. How do I change the JSL code to prompt the user to select a file manually within the analysis workflow? Or are there other solutions to this I am not thinking of?  Kindly,  TK

  CurseOfCheetah8

  Discussions |

  Dec 11, 2025 2:23 AM

  329 views | 4 replies

• How to get database connections that have been used in current JMP session

  Dear community, when I connect first time to a database (e.g. ODBC-connection that are listed in my ODBC Database administrator under Windows),
  I need to authenticate and it takes some extra time to set everything up. When I do it the second time during that session, it works w/o authentication and it is a little faster. How can I identify the connections that have been used during my current sessi...

  Georg

  Discussions |

  Dec 11, 2025 1:34 AM

  252 views | 3 replies

• How to get reference to a table within "On Close" in that table?

  Hi!   I need some help with getting a reference to the table within On Close statement of that said table. I have a simple script: GUI with "Open" button, that opens a data table, and a combo box with list of tables. I also keep track of the tables in an associative array with table names as keys and table references as values. I have a couple of legacy namespaces that I have to maintain in this s...

  miguello

  Discussions |

  Dec 10, 2025 1:28 PM

  196 views | 2 replies