cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
UserID16644
Level V

Select latest timestamp (String)

Hi all,

How can I select the rows with the same ID and code values but with the latest timestamp?

Sample Data:

UserID16644_0-1662012814397.png
Expected Output:

UserID16644_1-1662012863612.png

 

 

1 REPLY 1
jthi
Super User

Re: Select latest timestamp (String)

Convert the time to Numeric (Datenum) and then use

<< Select Where(:Time == Col Max(:Time, :ID))
-Jarmo

Recommended Articles