The World Statistics Day celebration continues here in the Community. We all need reliable data for sound decision making. Do you have a data source that you trust most? Head over to Discussions to tell us about it.
Choose Language Hide Translation Bar
robot
Level VI

Delete Duplicate Rows

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

Comments

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)

Article Labels

    There are no labels assigned to this post.

Article Tags