removing duplicate items in a table

bk

Hi All,

i have a table with ~20 columns and about 500 rows, two of these columns are Serial No. and Time stamp, and the rest is miscellaneous measurment data.

in some instances i have rows of data that have the same Serial No. but all other values are different.

my goal is to write a script to clean up the data table so that only rows with unique Serial No. are left.

I want to first select items with the same serial number and then identify from that subset the one with the latest Timestamp (which is just a numeric value), and delete the rest,

so i have a cleaned up table with unique Serial No.'s left.

Would appreciate if someone here could guide me how to write this bit of code. i've reviewd other examples on the forum, but am still struggling with this.

Thanks

Bble, ript

mpb

This code shows one way to go about it. I ran it against this data:

mydt = data table("MyDemo");

mydtsummary = Data Table( "MyDemo" ) << Summary(

    Group( :SN ),

    Max( :DT ),

    statistics column name format( "stat of column" )

);

mydt << Update(

    With( Data Table( mydtsummary) ),

    Match Columns( :SN = :SN ),

    Add Columns from Update table( :Max of DT )

);

mydt << select where(:DT == :Max of DT) << invert row selection;

mydt << delete rows;

mydt << delete columns("Max of DT");

close(mydtsummary, nosave);