Uploading a file with multiple sheets

[edesernia]

Hi,

I am trying to pull the most recent Excel file from a folder using the directory tool, however the file has many sheets. Is it possible to pull the most recent sheet from this file?

For example:

Folder contains files: Old, New

New file contains: Sheet 1, Sheet 2

Open Sheet 2

I am currently attempting to pull the file using the Directory tool, use the Sort and Sample tools to select the most recent, and then open it using the Dynamic Input tool. I know the Dynamic Input tool has an option to select sheet names, but my directory file is not a list of sheet names.

Thanks!

[ArtApa]

Hi @edesernia - You will need two Dynamic Input tools, like below:

[edesernia]

Would this only work if you know the sheet names? My issue is a new one will be added on a weekly basis