ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Automate input of excel files from a new folder for each monthly workflow

Cash
5 - Atom

Hi,

 

I complete a monthly process on Alteryx using data from 7 Excel files. Each month I collect the 7 new files (same name each month) and save them into a new sub folder named [YYYY MM].  

 

I then update the file paths in the 7 Alteryx Input tools before running the workflow.

 

The files are named the same way each month, the only thing that changes is the month of folder they are saved into [YYYY MM].

 

Is there a way to automate adding the same 7 file names from the new folder set up each month?

 

Many thanks.

Hamder83
8 - Asteroid

hi 

Try this, a simple macro to load all xlsx files of a specified folder 🙂

Let me know if this is not what you ment 

Cash
5 - Atom

Thanks! I can see it reads in each xlsx file from the folder. How do I then split out the individual file & line them up within the workflow?

(Sorry I'm a novice!)

Hamder83
8 - Asteroid

Maybe like this?

shreyanshrathod
10 - Fireball

Hi @Cash ,

 

I am assuming you have seven different inputs for 7 excel files.

That is why I have used 7 different Dynamic Input tools in my solution.

 

 

The folder path in the Directory tool will change according to your system.

The RegEx pattern will also change based on your folder path.

We can connect over the same.

 

As of now, I have multiple YYYY MM folders in my directory and my workflow is able to read files from folder 2021 04.

I am attaching the workflow package for your reference.

 

Let me know in case of any doubts.

 

Regards,

Shreyansh Rathod

Labels