I am trying to compare to documents in which which:
Document one has:
54654
87684
56468
89987
65498
Document two contains two rows to perform a vlookup
54650 1111
87642 1565
55462 2135
84586 5646
65480 9999
I want Knime to Match Document 1 to Document 2 by using the next lower value. So,
54654 would match or become 54650
87684 would match or become 87642
56468 would match or become 55462
89987 would match or become 87684
65498 would match or become 65480
I tried using binary dictionary but this would pull the lowest value for the all of the cells.
I have a question that sounds important to me before answering your question and may be providing an optimized solution:
Could it happen that two numbers in the initial column could match the same new lower value? Or otherwise, this is never the case ? Depending on this, the solution can be definitely different.
Sorry I cannot understand where the problem comes from without inspecting the workflow with the new data. Can you upload here the workflow with the new data to have a look at it ?
You’ve got an example to work on. The only thing you need to do is to think about your data. For e.g. are your data nummeric. If not it doesn’t work. Second you have only to exchange the datetime diefference node with a math formula node.
Good to know and thanks for this feedback. You have just checked your own answer as the solution. If the workflow I posted was of help and solved your problem, could you please validate the workflow as the solution ? There is a next to it for that.