Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Multiple Input files - Missing file from folder

Vishwak
7 - Meteor

Hi Team,

 

As per the process I am considering  multiple input files from the folder while building the tool.

Some times few input files are wont available in the folder, 

1) How can i designed and run  the tool without error - even when few files wont available in the folder.
2) is there any way to place  standing instruction in the workflow?  i mean Alteryx remind/intimate  us that ...hay this file missing in the input folder ?

Please guide me on this, Thanks. 


1 REPLY 1
Prometheus
12 - Quasar

You can create a chained app, where the first app uses a Directory tool to bring in the files, a Count Records tool to count the number of records in the list of files, then a Test tool to determine if there are records. If there are no files in the folder, your app fails. If there are files in the folder, then the second app runs.

Check App.PNG

Test Expression.PNG

Chain 2nd App.PNG

 

If you don't want your app to fail, then you can use a File Browse interface tool at the beginning of your workflow to give the user the ability to select the input file from the folder. If it's not there, then they don't have to run the app.

Labels
Top Solution Authors