Conditional Run

Hello All,

I would like to schedule a workflow to look at at flat file and only proceed with the remainder of the steps IF the row count is greater than 1 row in the file. For the life of me, I cannot think of what to use. I can use the count function but what then?

Thanks.

Moses

Workflow

Accepted answers

Maskell_Rascal

Hi @moperry

Using the Count, Append, and Message Tools we can accomplish this. See attached workflow.

Input:

Workflow w/ no output:

If we change the input to include more than one row of data, then this is our results.

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

Conditional Run.yxmd

All comments

mceleavey

Hi @moperry ,

use the Message tool:

this allows you to build in a check that will stop the process if the count of records < 2, or whatever you want.

Morgan_Thomas

Another approach could be something like the attached, which I have used before.

Count records ex.yxmd

Maskell_Rascal

Hi @moperry

Using the Count, Append, and Message Tools we can accomplish this. See attached workflow.

Input:

Workflow w/ no output:

If we change the input to include more than one row of data, then this is our results.

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

Conditional Run.yxmd

moperry

Thanks Maskell. I think this will be a solution I can use in my workflow. Much appreciated.

Thanks.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703