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

How to create Step Area Charts in Tableau?

2 mins read

Wed 20 May 2020

Alteryx Tool - Make Columns

4 mins read

Tue 12 May 2020

Exploring the ‘show only relevant values’ option

2 mins read

Sun 10 May 2020

Alteryx Server Beginner - How to publish an Alteryx analytical app with macro to the Gallery?

1 mins read

Thu 07 May 2020