Check for new Records

I have a table that contains a list of exception codes that are entered by users on an ad-hoc basis.
I need to create a daily report to check if a new record has been added to this table and if there are new codes I need to capture them. How do I do this in KNIME?

You could construct a workflow like this that collects the new data each day and writes an excel report which lines were new in that run.

You could manipulate that further to your needs.

kn_example_check_for_new_record.knar (62.0 KB)

1 Like

Thank you! I actually ended up using 2 outer joins to flag the rows that didnt have any equivalent in both new and old tables.
But Reference Row filter would work as well.