How to read data from multiple excel files ?

[dsneeraj]

How can I configure the workflow to automatically read data from multiple Excel files located in a specific directory? I need a solution that handles new files added to the directory without manual intervention.

[leefarrell · Accepted solution]

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.