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!!

Workflow

Input

Topic of Interest

Output

Tips and Tricks

Macros

Common Use Cases

Optimization

Accepted answers

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.

Screenshot 2025-02-04 092234.png

All comments

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.

Screenshot 2025-02-04 092234.png

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!!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703