Functionality to automatically access input files

Saleem29

Hi,

We have built an Alteryx model that would require accessing multiple input files to arrive at the final output. Currently we are manually linking these input files for the model to perform further processes and provide an output.

Could you please let us know if there is a functionality wherein a model would be able to automatically pick these input files from a specific directory without any manual intervention and provide us with the final output?

Thanks.

Raj

Yes, Alteryx provides functionality to automate the process of accessing input files from a specific directory without manual intervention. You can achieve this using Alteryx's Input Data tool and the Directory Input tool.

Here's a high-level overview of the steps you can follow:

Start by adding an Input Data tool to your workflow. Configure it to read a single input file, specifying the file format and settings as required.

Next, add a Directory Input tool to your workflow. This tool allows you to generate a list of files within a specific directory.

Connect the Directory Input tool to the Input Data tool. This connection will provide the list of files from the directory to the Input Data tool.

Configure the Directory Input tool to specify the directory from which you want to read the input files.

Set up a loop or iterative process using the Directory Input tool's output. For each file in the directory, the loop will execute the subsequent steps.

Connect the looped output of the Directory Input tool to the rest of your workflow, allowing each file to be processed in the desired manner.

Finally, you can aggregate the outputs of each iteration to obtain the final output of your Alteryx model.