Welcome to the JMP User Community!

Latest Discussions

• Eliminating Duplicate Rows (keeping first duplicate)

  I know this has been discussed before, but I'm looking for suggestions for my particular situation. I have a very large data table (~50 columns x 50,000+ rows). I need to check for "duplicate rows", where duplicate means the rows match in three columns (eg. ColA, ColB, and ColC). When duplicates exist, I need to delete all except the first of the matching rows.
  
  Ideally, I'd like to do this with ...

  

  Discussions |

  Jan 21, 2024 7:01 AM

  36561 views | 7 replies

• Custom Binning - how to edit the bins?

  Wow, custom binning even works with dates, cool! There is even a possibility to edit the binning. But: quite uncomfortable to type in the dates in seconds and to correct the labels manually.What do I have to change in my workflow to be able to enter the "dates" in a usual format - and to get the labels adjusted automatically?
  
  (view in My Videos) dt = Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" ); d...

  hogi

  Discussions |

  Jan 21, 2024 2:33 AM

  1371 views | 0 replies

• Custom Binning - how to edit Transform Column settings?

  In Jmp16, Custom binning was introduced: Interactive Binning - New in JMP 16 Very useful, thanks a lot to the developers! There are 3 ways (or more?) to use this feature:In the data table, via the menu:  Col/Utilities/Make Binning Formula ...
  or via right click / New Formula Column/Distributional */Custom Binning ...
  
  
  for plot modes like Overlay, Color, X/Y Group, Page:
  via right click/Levels/Custom L...

  hogi

  Discussions |

  Jan 19, 2024 10:50 PM

  1024 views | 0 replies

• check whther a project is already open

  Hello, I have a script which is part of an add-in. When the script is launched, it triggers the creation of a project (project=new project (...)). However, when I'm debugging the script, I typically run it with a project already open and use the code project=this project(). I would like to make the script smarter so that if a project(s) is already open then it run automatically into the open proje...

  Sburel

  Discussions |

  Jan 19, 2024 5:07 PM

  1935 views | 2 replies

• Data Table for Multiple Users

  Hi JMP Community, I created a data table that will used by a few colleagues to update table rows with new weekly data and to pull charts & graphs from. The file is stored on a SharePoint folder so we can all access it. The problem is if one user has the file open and another user opens the file, it will create a copy with that users computer ID.
  
  Is there a way for multiple users to access this file...

  CTrahon0526

  Discussions |

  Jan 19, 2024 9:45 AM

  1183 views | 0 replies