Move file based on an excel file

KNIME Analytics Platform
#1

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 :slight_smile:

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

#2

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
#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.