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.

Load specific template saved in multiple paths

Hizah
5 - Atom

Hi Community

 

Each quarter local Finance of each country and entity inputs a template saved in each country/entity folder in our server drive.  How do I load all the templates into my workflow so that I can merge all the data for further data prep?

 

There is potentially 50 unique file paths that I need to draw the data from.  Below is an example of a file path of a Singapore entity.

 

X:\Tax\COUNTRYSHAREDFOLDER\Singapore\ABC Co\[Year]\[Quarter]

 

The year and quarter change depending on the year/quarter of the close.

 

Hope you can help me.

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Hizah 
Have you tried the search subfolder option?

Capture33.PNG

Hizah
5 - Atom

Thanks for your reply!

 

I am not sure how this works.  Where do I indicate the full paths of the template in each country/entity/year/quarter subfolders for the files connection? 

 

Labels
Top Solution Authors