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