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

KNIME Analytics Platform
1

Hello,

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.

2

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.)

2 Likes
3

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.

4

You can check out Table Row to variable node
BR

5

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