Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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