Hi there. I am new to Knime and I can’t find the answer any where. I am starting with a database table “Production Info”. I am trying to make an app where the user can input a production number string. I want to take their input and compare it to the production number column in “Table 1”. If their number is not in that column, I want to display text that says “Your number is invalid”.
How can I compare the user input to Table1?
@UnLucky_Pickle Welcome to the Forum Community. This should give you a start.
Compare User Input to Table.knwf (101.6 KB)
Sorry the workflow I posted won’t work. Must have still been asleep when I did it. Try this one. It depends on your production number sorting above “ZZZZZZ”. This should be ok for any realistic number set. But check it.
Compare User Input to Table.knwf (117.0 KB)
Hi rfeigel. It looks like the file still does not work when downloaded. Thanks
Never mind I got it. I must also be asleep lol
If the workflow meets your needs please mark “Solved.” If you have problems, give me the details.
FYI - I tried replacing the Sorter and Row Filter nodes with the Top k Row Filter node which does both sorting and filtering in one node. I thought that might improve performance. Actually the performance (checked with Timer Info node) was marginally worse.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.