Welcome to the JMP User Community!

Latest Discussions

• 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

  164 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

  253 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

  198 views | 2 replies

• Custom Desirability in Bayesian Optimization

  I am trying to do multi response Bayesian optimization in JMP Pro - Apologies if this is a stupid question but, how do I set custom desirabilites for each response and have them carry through multiple iterations? When I use "set desirabilities" it is not clear these are carried through to the run / batch  selection process OR to any further BO iterations.

  OliverPickburn

  Discussions |

  Dec 10, 2025 12:17 AM

  246 views | 2 replies