Joining two tables based on date ranges

[aworker]

Hi @ViTLe

My pleasure to help

@ViTLe

It seems like a very simple problem but I can only make it work if each schedule range is unique and only one car per schedule range but in my car, you can have different cars driving during the same schedule, which is what I am stuck on.

Joining tables by -date ranges- is not something trivial at a first glance so I understand the difficulty to get to a solution

Please find below a possible solution. The -Sorter- node is not stricty needed appart from easing the understanding of the results. The Chunk Loop is neither strictly needed but it will help you to optimize the use of your computer memory if you have huge tables as you said. Otherwise, it could be done without it. I let you to experiment with it

20211204 Pikairos Joining two tables based on date ranges.knwf (317.8 KB)

Hope it helps

Best

Ael