Thank you Jonathan for saving us from Dashboard Day2! So how do you import multiple files from folders within folders within folders into Alteryx using the Directory Tool?
Step1:
- Import a single file using the Input Data Tool; Connect it with a Control Parameter;
- Update the entire file path;
- Connect a Macro Output; Save the Macro.
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/04/Capture1-3-1024x780.png)
Step2:
- Connect the Macro with the Directory Tool;
- Write the highest hierarchy of your file path folder under ‘Directory’;
- Indicate the file type that you are looking for under ‘File Specification’;
- Tick the ‘Include SubDirectories’ box.
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/04/Capture2-2.png)
Step3:
- Choose ‘FullPath’ under the Choose Field dropdown menu when configuring the input macro
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/04/Capture3-1.png)
Connect with the Output Data Tool, it’s done!
Here is my dashboard for Dashboard Week Day2:
![](https://www.thedataschool.co.uk/content/images/wordpress/2020/04/Screenshot-237-1024x619.png)