Joining two tables based on date ranges

[mlauber71]

@ViTLe indeed on option would be to use a H2 database to realise a BETWEEN join.

Efficient way of doing a JOIN ... WHERE ...

Well, not a particularly sophisticated idea but you could try and use a local H2 database to join two datasets by time ranges. Depending on the power of your machine and other factors that might work. I tried it with files of different sizes and at least it gives you a result. [image] Until there is a solution in KNIME you could explore further the possibilities of using SQL to make the join more efficient. I took from this older entry: There might be some special limitations when workin…