Use the Input Data Tool:
In Alteryx, drag the Input Data tool onto your canvas.
Set Up Dynamic File Path:
Click on the Input Data tool, and select the folder path instead of a specific file.
Use a wildcard (e.g., *.xlsx) to include all Excel files in the directory.
Configure File Reading:
If needed, use the Directory tool to list files in the folder.
Connect this to a Dynamic Input tool to process each file.
Automate Workflow:
Set up a schedule or use Alteryx Server to run the workflow automatically at regular intervals.
This setup will automatically read and process all Excel files in the directory, including any new files added.
