Hallo,
I´d like to scan through folders and their Subfolders (in a company network folder structure) and read in newly added mdf files that I have not read in yet (I don´t want to read in the same file again and again). Since filename has date and time, the name is unique, so even if they get moved arround only path to the file needs to be updated in the Output file. I also want to set files as invalid, when the mdf file is not present anymore.
Then I´d like to scan through the newly added measurements (mdf file) and find events that I want to highlight in a Output table.
So I know:
in file xyz, which is located here (//Serverpath/Link/to/file), at time 123 there is event abc + further information (Temperature, speed, …)
For each event one line in an excel output sheet should be present.
I want to execute this workflow once a day (evening/night, best start automatically at a certain time), to add new events and mark events as “file not existing anymore”
After that, for each event Type I´d like to use a different workflow to analyse the events in the mdf files in detail and I want to use statistics, Histograms, and so on ( not fully clear how and what ) first I need to understand how I do the fist part.
MDF Reader need an input for that to get the path from a List, I assume.
Or maybe there is a better way of doing what I want to do.
Maybe also not possible with Knime and I need to write python code to do so?
Thanks for your Help
Regards
Armin