I am new to Knime. I like it so far.
Here is me question:
I get a report every month including data form some other firms. This reports will have the same form every Month only other data. I want to open this reports whit Knime without having to change the URL every Month.
Is there a way to open allways the newest file in a folder with a Reader?
I hope you understand what I mean. I am not a native speaker.
Thx for your help
Try to use these nodes (also see attached image):
- List Files
- String to URI
- File Meta Info
- Row Filter
I now have the URI of the newest file in my folder. But how do i get the Reader to use this URI? Are there special Raiders that gent the URI form another note?
The files I need to open are of the type xls and csv.
Then you expose a row as variables with Table Row to Variable node and connect variable ports to XLS Reader and CSV Reader (see attached image).
One note about XLS Reader. When you define a String location variable as a file location, node configuration cannot be saved. First select random (or empty) xls file as normaly, then set variable location (see image xls.png).
With CSV Reader there are no issues (see image csv.png).