How to connect multiple files using Directory in alteryx which should automatically update for upcoming month along with figures updated?
Solved! Go to Solution.
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.
Thank you so much. I have tried this and it worked 😊
glad i was able to help! enjoy building Work Flows! <3