How to upload automatically four Excel files by creation date (latest four files)


I want to upload automatically the latest four excel files from the same storage location. Knime should always upload four different excel files by creation date. How can I do that with Knime? Maybe with a loop ?

Thank you.

If the date is contained in the file name you could use “Top K Selector” node and sort by file name descending, and grab select the first 4 rows. (This assumes “List files” node precedes the top k selector node.)


Thank you:) it worked:)

One additional question:

So I want to add in the column name the date from the URL. I think this works maybe with a variable. Do you know how to create a variable out of the URL name?

Thank you.

You can check out Table Row to variable node

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