Configuring joiner for an "In-between" lookup?

KNIME Analytics Platform
1

Hello all, I’m a new Knime user, stuck on a problem. I have a large csv file that I am trying to join to xlsx. In the xlsx I have an id number. In the csv I have a lower range of id numbers in one column, and an upper range in the next column. I need to join the files where the xlsx id is between the lower and upper columns in the csv. For example:

csvLowerNum    csvUpperNum    xlsxId
1                10                5

Does anyone have an idea how to do this?

Thanks in advance

2

See this conversation. Join tables based on a date range