Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Comb Through Folder/Subfolders Looking For Files By Type Or Name

robertfishel
8 - Asteroid

Hey Alteryx fans, I'm back with another question.

 

Is there a macro, or a way to build a workflow, that will comb through a specified folder containing subfolders looking for, as an example, the existence of Excel files.  I need to make sure that a directory of of folders does or does not contain any Excel workbooks.  Thanks!!

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

@robertfishel,

 

The DIRECTORY tool has the option to search through directories and sub directories and get you a complete "DOS" listing of all files.  You can specify a "File Specification" of *.xls*

 

 

Your output will have all of your Excel files.

 

Cheers,


Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
robertfishel
8 - Asteroid

Thank you!  Much appreciated!!

Labels