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