Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Uploading a file with multiple sheets

edesernia
6 - Meteoroid

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!

2 REPLIES 2
ArtApa
Alteryx
Alteryx

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

 

ArtApa_0-1661308038094.png

 

edesernia
6 - Meteoroid

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

Labels
Top Solution Authors