Welcome to the JMP User Community!

Latest Discussions

• JMP Query Builder -- how to apply "HAVING" feature?

  Hello all, I have several SQL queries with "HAVING" features. I would like to see whether it can be set in JMP Query Builder. I searched over this community, but I did not see discussions on it (maybe I missed?). I understand there is one custom SQL feature that can be used to achieve this function. But the issue is in that way all nice JMP Query Builder interactive features won't be seen any more...

  TG

  Discussions |

  Feb 5, 2021 3:16 PM

  2306 views | 4 replies

• Closing a JMP modal dialog using JSL

  Hi Everyone!I am working on a script to import excel files stored in SharePoint.  So far I am able to open the web page to SharePoint site and import the Excel sheet.  However, there is a JMP modal window that  opens called "File Download" with the user options of Open, Save or Cancel.  I just need the script to either not open OR to Cancel this window. I could not locate a "File option" setting i...

  Onjai

  Discussions |

  Feb 5, 2021 2:07 PM

  1797 views | 1 replies

• If select where does not find value then do x else continue with rest of script

  Hello and Happy Friday,   I am trying to find a way around this one. I have a part in my script where it uses the following below. The issue I have is when it does not find the value ABC in Column1. Basically, I want it to where it runs the code below but if it does not find ABC, then I want it to save a blank table (csv) and stop running the rest of the code. If it does find ABC , then I want it ...

  Josee

  Discussions |

  Feb 5, 2021 12:39 PM

  884 views | 1 replies

• error message not understood

  Hi, Why Have I this message, I don't understand what it means... regards

  Françoise

  Discussions |

  Feb 5, 2021 12:05 PM

  2206 views | 6 replies

• Select middle 90% range using quantiles

  I have a Numeric Continuous column labeled as Height with several hundred height values. I want to exclude outliers by just using the middle 90% range of data. I am trying to script it in JSL by selecting all rows below 5% quantile and above 95% quantile and then exclude them. But I am not able to make it work by using script below. I will appreciate any guidance. RowsBelow5PCTL = dt << get rows w...

  rverma

  Discussions |

  Feb 5, 2021 11:09 AM

  1818 views | 2 replies