Welcome to the JMP User Community!

Latest Discussions

• Alternative to "Select duplicate rows"

  Hey guys,
  I'm looking for an alternative to the "Select duplicate rows" function that does not exist in JMP12. 
  My aim is to delete duplicate rows by column value, with an exception of specific valueFor example, if I have this my data table, I want to leave the first substances of column "Color", With an exception that if the "Color" column value is Yellow, leave all these rows and don't delete them...

  Stas

  Discussions |

  Feb 6, 2021 5:09 AM

  1706 views | 3 replies

• Mise en tableau des données

  Bonjour,lorsque on fait une mise en tableau des données, peut-on mettre intitule d'une colonne sur deux ligne lorsqu'il est trop long.Si oui commentMerci

  GPL12

  Discussions |

  Feb 5, 2021 10:19 PM

  1152 views | 2 replies

• 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

  1799 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