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

by Sijia Wei

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

© 2022 The Information Lab Ltd. All rights reserved.