How to Join by date range

I have two tables as below.

(Table 1)

(Table 2)

(expected result)

I want to join by date range and add the week column, but I found that there is no node like this.
I was wondering if there are any way to join by date range.


@hhkim welcome to the KNIME forum

You could take a look at this approach

In addition you could take a look at other threads from the forum:


Thank you for your help.

But I’d like to join by range without SQL or cross join if possible.


Hi @hhkim , and welcome to the Knime Community.

The only way to do this without SQL would be via a cross join and then apply rule engine to match the range.

This can be quite resource taxing. The most efficient way is via SQL, and if you check what @mlauber71 suggested, you don’t have to set up any db server. It’s all virtual and done via memory.

1 Like

Thank you so much.
I’ll check again the example.

1 Like

I think this can be done with a dictionary binner node

1 Like

@Daniel_Weikert maybe you could provide an example. Could be an interesting addition.

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.