cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. ET on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
Delete Duplicate Rows
robot
Level VI

This JSL script will delete duplicate rows in a data table.  The first unique occurrence of each row is preserved.

Comments
guy_yosef

I usually do summary of all columns. if its the same value i dont catre which line is kept

but to get only the last results... i need to do summary by max date and then join it with the orginal table (it happen alot due to rework or remesure)

Recommended Articles