# Move file based on an excel file

**URL:** <https://forum.knime.com/t/move-file-based-on-an-excel-file/28051>\
**Category:** KNIME Analytics Platform\
**Created:** [October 18, 2020, 2:36am UTC](https://forum.knime.com/t/move-file-based-on-an-excel-file/28051 "2020-10-18T02:36:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vonfersk](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/v/50afbb/32.png) [@vonfersk](https://forum.knime.com/u/vonfersk)\
**Post date:** [October 18, 2020, 2:36am UTC](https://forum.knime.com/t/move-file-based-on-an-excel-file/28051/1 "2020-10-18T02:36:19Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![knimediger](https://forum-cdn.knime.com/user_avatar/forum.knime.com/knimediger/32/19981_2.png) [@knimediger](https://forum.knime.com/u/knimediger)\
**Post date:** [October 18, 2020, 7:05pm UTC](https://forum.knime.com/t/move-file-based-on-an-excel-file/28051/2 "2020-10-18T19:05:45Z")

</div>

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](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](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](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

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [October 25, 2020, 7:05pm UTC](https://forum.knime.com/t/move-file-based-on-an-excel-file/28051/3 "2020-10-25T19:05:46Z")

</div>

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