Filtering rows based on latest timestamp

[cason]

Hi,

I have a table that looks like this:

ItemID - Timestamp - Value

1 2020-04-30 11:22 232
2 2020-04-30 11:22 134
3 2020-04-30 11:22 23
1 2020-04-30 10:22 222
2 2020-04-30 10:22 112
3 2020-04-30 10:22 4

What would be the best way to select the row with the last timestamp for each Item ID dynamically? The result I’m looking for this in a table:

1 2020-04-30 11:22 232
2 2020-04-30 11:22 134
3 2020-04-30 11:22 23

Thanks for your help!

[elsamuel]

Here’s a quick workflow that works with the data you provided. It should get you started:

[ipazin]

Hi there @cason,

if I got you right Duplicate Row Filter can be used as well

Br,
Ivan

[cason]

thanks @elsamuel and @ipazin for the help with this. I finally used the groupby function to solve this since I’m running on Knime 3.6 at the moment and duplicate row filter requires an upgrade which I don’t have time for right now. thanks again.