Hello. I have two tables as below. (Table 1) |ID|Value|Date|Dist| |A001|1|2021-01-01|10| |A001|1|2021-01-01|15| |A001|2|2021-01-05|10| |A001|2|2021-01-05|15| |A001|3|2021-02-07|10| |A001|3|2021-02-07|15| |A002|4|2021-02-25|20| |A002|5|2021-03-04|20| |A003|6|2021-03-23|30| (Table 2) |StartDate|EndDate|Week| |2020-12-27|2021-01-02|53| |2021-01-03|2021-01-09|1| |2021-01-10|2021-01-16|2| |2021-01-17|2021-01-23|3| |2021-01-24|2021-01-30|4| |2021-01-31|2021-02-06|5| |2021-02-07|2021-02-13|6| |2021-02-14|2021-02-20|7| |2021-02-21|2021-02-27|8| |2021-02-28|2021-03-06|9| |2021-03-07|2021-03-13|10| |2021-03-14|2021-03-20|11| |2021-03-21|2021-03-27|12| |2021-03-28|2021-04-03|13| (expected result) |ID|Value|Date|Dist|StartDate|EndDate|Week| |A001|1|2021-01-01|10|2020-12-27|2021-01-02|53| |A001|1|2021-01-01|15|2020-12-27|2021-01-02|53| |A001|2|2021-01-05|10|2021-01-03|2021-01-09|1| |A001|2|2021-01-05|15|2021-01-03|2021-01-09|1| |A001|3|2021-02-07|10|2021-02-07|2021-02-13|6| |A001|3|2021-02-07|15|2021-02-07|2021-02-13|6| |A002|4|2021-02-25|20|2021-02-21|2021-02-27|8| |A002|5|2021-03-04|20|2021-02-28|2021-03-06|9| |A003|6|2021-03-23|30|2021-03-21|2021-03-27|12| 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. Thanks.

How to Join by date range

mlauber71 October 25, 2021, 1:09am 2

@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:

2 Likes