How to filter a KNIME Data App table by the latest date?

KNIME Analytics Platform
1

Date Filter Data App.knwf (60.2 KB)

wellness_dummy.csv (19.6 KB)

Hi everyone,
I’m new to KNIME Data Apps and I’m struggling with something that seems simple: I want the Data App to show only the rows from the most recent date in my dataset.

My table has a column Date_ddmmyyyy (string like 12/08/2025).
What I want to achieve:

  • Automatically detect the latest date in the data

  • Filter the table so the Data App shows only those rows

  • Later allow the user to pick another date with a widget

I tried using a Date&Time Widget + flow variables connected to a Row Filter, but I can’t get it to work, and I couldn’t find a similar example in the forum.

I’ve attached a small workflow and a sample CSV.
Any advice or a simple example of how to filter by the “latest date” would really help. Thank you very much!

2

Hi,

is it just a row you want to have? You can use the top-k selector.

3

Hi,

The Top-k Selector would work for getting the latest date, but when I select a different date and hit the refresh button, the table in the Data App View doesn’t update its rows.

4

Hi,

You could try this solution.

2 Likes
5

That works perfectly!

Thanks!

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.