How to check Excel file (in PC) is updated contents and if yes(its updated), continues send email.

[cppong]

Hi everyone,
Need some help.

I am working to create a snippet script. The purpose of the script is to check contents in the excel file (in PC) are updated (changed from the previous file after the user copies the new file overwrites it) or not… if the file was changed (updated), let send the email to users BUT if not, let the script end(do nothing)

I think we will use node “Table switch” to select the decision result(input)? or another node would help to solve this?
Thanks for your time and help.

Here is my wiring.

[mlauber71]

@cppong maybe you can take inspirations from these solutions / components:

Start a Workflow, e. g. a database query, after a certain time

You could absolutely combine the approaches, I would think. Thank you @kienerj for pointing to this feature. Another interesting function could be this component by @gab1one that would wait for a file to change. In order to bring this into a ‘looping system’ - some changes might be necessary. In my example I tried to do a small such system with generic KNIME nodes.

Start a Workflow, e. g. a database query, after a certain time

@USCHUKN1ME I tried to build a system you might be able to expand and use. The idea is to have a workflow that would iterate a number of times (v_number_of_intervals) with a set interval (of seconds) between (v_seconds_interval) them. The workflow looks for a trigger_file.csv if this file has changed from the last time the loop has run a component would be executed. If the file has not changed nothing would happen. Admittedly not the most elegant way but you could build a small automatic execu…

[cppong]

Thanks @mlauber71 let me walk thru the post that you recommended and gonna get back if there is the solution for me. Thanks again.