How do you import data from folders within folders within folders… - The Directory Tool in Alteryx

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.

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.

Step3:

  • Choose ‘FullPath’ under the Choose Field dropdown menu when configuring the input macro

Connect with the Output Data Tool, it’s done!

Here is my dashboard for Dashboard Week Day2:

https://public.tableau.com/views/FlightWorkbook/Dashboard?:retry=yes&:display_count=y&:origin=viz_share_link

Author:
Sijia Wei
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab