Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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