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