Can I have an example of Directory / Dynamic Input Tool for this situation please?
Input data from all .xlsx files --> that contains a sheet named "State" --> in this folder --> from this drive
Thank you for your help.
Solved! Go to Solution.
This is the ultimate guide: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
It even has a Batch Macro for you at the bottom.