Input all worksheets in the most recent Excel file?

[KateC]

Is there a way to accomplish this using a Directory Input? I need all of the worksheets (3) in the most recent version of an Excel file, and I need to retain the sheet name as a field. 

[RolandSchubert]

Hi @KateC ,

the Directory tool return not only file names, but also time stamps (last access, last write). You can select the last file e.g. using Sort/Sample tool. You can use a macro to find all sheets in this file, create the complete name using a formula tool and use an additional macro to read all data.

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

[KateC]

Thanks! I am unable to open the sample workflow; apparently we don't have the latest version of Alteryx here.

[RolandSchubert]

I've set the version to 2021.1. and attached the files.

btw.: you can edit workflows using a text editor and change the version.