Lag Column - based on two or more conditions

[mlauber71]

I would have to have a closer look at your example but this could be a job for an SQL window function. You could explore this thread:

RANK variable in DB

@chanoufi_marwa one way to do it is to use a Hive environment and a RANK function. Other SQL databases should also support RANK like H2 (Window Functions). Hint: the KNIME implementation of H2 currently has the version 1.4.196. Unfortunately with H2 the RANK etc functions are only supported with version 1.4.198 or later … @ScottF might be an interesting case to update that version

The KNIME implementation of H2 database does not support that yet (@Iris - window functions would really improved the local H2 implementation. So maybe there is a chance for an update).