remove duplicates with condition and add the last date
External resources
- School of duplicates - and how to deal with them
- School of duplicates - and how to deal with them - H2 version
- use H2 to produce a Position / Rank number within a group variable (window functions)
- more H2 database examples from the KNIME hub
- H2 and SQLite driver for window functions
- (38543) - forum entry
- (38532) - related forum question
Used extensions & nodes
Created with KNIME Analytics Platform version 4.5.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.5.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.5.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.5.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.5.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.5.0
Legal
By using or downloading the workflow, you agree to our terms and conditions.