remove duplicates with condition and add the last date

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