We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to connect multiple files using Directory

SusmitaM
6 - Meteoroid

How to connect multiple files using Directory in alteryx which should automatically update for upcoming month along with figures updated?

3 REPLIES 3
shancmiralles
11 - Bolide

the files should be (preferably) in 1 folder.. 
default of the directory tools configuration is 
*.* (asterisk dot asterisk)

means the tool will pull all files in that folder.

now, all files you need in 1 type of file?

*.xlsx 

is an example.. means  all files under excel type will be pulled...

after that if the files does have the same content (format) you can use dynamic input tool... if not then you'll need a batch macro to pull all data in the files that you need.

SusmitaM
6 - Meteoroid

Thank you so much. I have tried this and it worked 😊

shancmiralles
11 - Bolide

glad i was able to help! enjoy building Work Flows! <3

Labels
Top Solution Authors