Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

input file with no data

Nicolaas_Vercruyse
7 - Meteor

Hello,

 

We have a workflow with multiple txt input data files.

But sometimes on of them is completely empty, and then the workflow doesn't want to run.

Any ideas how to solve that they ignore empty data input files and still run with the other input data files?

 

Thanks,

Nicolaas

3 REPLIES 3
jdminton
12 - Quasar

Can you share an example of how your workflow looks? I'm thinking you could use a dynamic input tool since it sounds like the input file doesn't exist (versus an empty file).

Nicolaas_Vercruyse
7 - Meteor
 

See below. So sometimes the second txt file is empty, but it does exist.

Schermafbeelding 2024-01-17 125552.jpg

and we receive this error

Schermafbeelding 2024-01-17 130123.jpg

jdminton
12 - Quasar

The problem here is that the file contains nothing. If that is the case, you can get around this with the directory and dynamic input tool. You will need to modify the attached workflow for your files to connect correctly, but the highlighted section shows how to do this. The directory tool provides the file sizes and you can exclude the size 0 files to only have the non-blank text files flow through the workflow. Let us know how this goes!

Snag_27c1c5c4.png

Labels
Top Solution Authors