If condition with strings and date

[mlauber71]

@AdrianaFerro you might want to take an initial look at this:

remove duplicates with condition and add the last date – mlauber71

Please note the H2 driver has been updated in order to allow Window functions.