Hello all!
I’m new in Knime. I have a question. I have an excel file in the first colum has a name that I need. In the other input I have the file b (and the file b has inside the name) I need to compare both and if the name is the same that the file b has inside move to another file.
Example:
File a:
House
Bed
Fire
File b:
Fire
So move the file b in another path
Another example
File b:
House
Bed
Fire
File b:
Dog
Don’t move the file.
I don’t know how I can compare this. Some ideas?
Thanks
Hello @vonfersk ,
Welcome to KNIME.
I’m not sure whether I understood fully your requirements.
From the given information I would propose to read the two files using either the xls Reader Node (deprecated) https://nodepit.com/node/org.knime.ext.poi2.node.read3.XLSReaderNodeFactory or the File Reader Node https://nodepit.com/node/org.knime.base.node.io.filereader.FileReaderNodeFactory
Then you can use the Joiner Node https://nodepit.com/node/org.knime.base.node.preproc.joiner.Joiner2NodeFactory
As one result from the Joiner Node you will get the entries which are in both tables.
HTH
2 Likes
system
Closed
October 25, 2020, 7:05pm
3
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.