Stop running the workflow if no files are present

[sneha_bhiwagade1]

Hi All,

I have a directory tool which give the details of the number of files and full path. Post that i have a batch macro which reads individual files with different sheets.

if i get zero records after reading the directory tool (means if no files are present in the folder) i would like to stop the running of Batch macro. 

Could you please help me on the same. 

Many Thanks in advance!!

[JosephSerpis · Accepted solution]

Hi @sneha_bhiwagade1 I would recommend a message tool with a combination of count tool and append fields tool to count the amount of files the count tool does produce 0 if no data is provided and the message tool has a feature to stop the workflow with a custom message of your choosing.

[sneha_bhiwagade1]

@JosephSerpis thank you!!

[sneha_bhiwagade1]

Hi All, 

@JosephSerpis 

I am having 3 different input folders. example A, B, C

having three different macros to read the input files from three folders A, B, C.

In each macro I am using directory tool to read input files.

And the output of each three macros is merged and then generates a final output file.

but the scenario is that when files are missing in C folder still workflow should generate a final output file without any error.

Many Thanks in advance!!