topic Comparing two rows with the same time stamp and picking the higher value from a different column in Discussions

Comparing two rows with the same time stamp and picking the higher value from a different column

nv11 — Thu, 07 Mar 2024 20:51:37 GMT

Hi, I have a dataset where by I have a single column with minute by minute data (time stamped) and in many cases the same minute is duplicated. For those instances, there is another column with different values. How do I find duplicated timestamp rows and pick the max. value between them e.g.

Initial Table

Time Flow

12:00 345

12:01 123

12:01 456

12:02 223

12:02 112

12:03 234

Final Table

Time Flow

12:00 345

12:01 456

12:02 223

12:03 234

Thank you. FYI - using JMP Pro 17 and I am an amateur (2hrs of experience).

Re: Comparing two rows with the same time stamp and picking the higher value from a different column

Thierry_S — Thu, 07 Mar 2024 21:00:08 GMT

Hi,

I suggest using the Table Summary tool with the Flow column set to MAX and the Time column set to Group.

Best,

Re: Comparing two rows with the same time stamp and picking the higher value from a different column

nv11 — Thu, 07 Mar 2024 21:06:15 GMT

Thank you for the feedback - unfortunately I might be too early in my JMP journey to understand how to apply this solution

Re: Comparing two rows with the same time stamp and picking the higher value from a different column

txnelson — Thu, 07 Mar 2024 21:08:38 GMT

Go to the Tables pull down menu and select Summary