How to do an IF/LOOKUP from two sources?

Hi @elnicocruz and welcome to the KNIME community

If my understanding is correct, you are wanting to join Table 2 to Table 1 where the Initiated Date is between 1st Day and Last Day.

Unfortunately, the standard joiner nodes in KNIME which you would normally use for performing joins do not include range-matching.

However, you are not the first (and won’t be the last) to want to do this. As it happens, I recently added some components to the hub to provide a workaround here.

One such component is

It’s newly written in the past few days but I think it should work for you.
Take a look at (the initial part of) this thread for some background

4 Likes