Stop part of workflow based on condition

Hi, I have a workflow which has multiple branches each with their own output and email. I've scheduled this workflow to run every hour. For only one of the branches, I want the output and email to be generated every 3 hours. Is there any way I can do this?

Since I'm using the Scheduler, I'm wary of using the Crew Runner Macro as it is not supported by Alteryx.

Update: @fmvizcaino helped me stop output file generation. Now I need the email to not be sent out as well. Currently, the emailer still send out the message with no file attached.

Macros

Scheduler

Accepted answers

fmvizcaino

Hi @abarmecha ,

Attached is an example showing one way of doing it.

The idea behind this workflow was to filter all data based on the specific hour you want. If there are data available, the output is produced, if not, the file will not be generated.

To control the file generation, I have used the 'take file from field' option in output data tool, as showed in attached workflow.

If that is what you need, please mark the answer as correct, if not, let me know what I can do to help you further.

Best,

Fernando V.

2019-11-25 Stop part of workflow based on condition.yxmd

All comments

fmvizcaino

Hi @abarmecha ,

Attached is an example showing one way of doing it.

The idea behind this workflow was to filter all data based on the specific hour you want. If there are data available, the output is produced, if not, the file will not be generated.

To control the file generation, I have used the 'take file from field' option in output data tool, as showed in attached workflow.

If that is what you need, please mark the answer as correct, if not, let me know what I can do to help you further.

Best,

Fernando V.

2019-11-25 Stop part of workflow based on condition.yxmd

DiganP

@abarmecha What is the harm done if the output is generated every 1 hour rather than the 3 hours? Just look at the output every 3 hours! You can create a separate workflow with that specific branch and schedule that workflow to run every 3 hours as well.

@fmvizcaino trick would work too.

abarmecha

Hi @fmvizcaino

Thanks for the response. The reason why this doesn't quite work for me is because even though the output file is not generated in the way you've modified the workflow, the email still gets sent (I should have mentioned this in the original question. My apologies). I've updated the description.

abarmecha

Hi @DiganP

I've updated the problem description which sort of answers your question.

To be more specific, the team who uses the output file/email don't want their mailboxes to be clogged with hourly emails. They prefer every 3 hours. That's why I'm trying to run part of the workflow only every 3 hours.

My apologies for the confusion.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703