Welcome to the JMP User Community!

Latest Discussions

• Need help converting a date format from character to numeric in JMP 15

  Hi, My Excel sheet has the date format as: Wednesday, November 18, 2020, 12:45:00 PM. Upon importing into JMP 15, it is read as a character. Can you please share a method to convert the date from its character format to a numeric-continuous format (e.g., yyyy-mm-dd hh:mm)? I have attached a JMP file for your reference.Is there is a way to apply the correct (numeric) date format during import?Thank...

  sumit_dutta

  Discussions |

  Feb 6, 2021 8:18 AM

  2047 views | 2 replies

• 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

  1708 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

  1153 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

  2307 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