Conditional Run

[moperry]

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

[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.

M.

[Morgan_Thomas]

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

[Maskell_Rascal · Accepted solution]

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

[moperry]

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

Thanks.