Enable container based on records count

[RavitejaBaratam]

HI Team,

I have a workflow, I am fetching data from one excel file and writing into another excel file using alteryx. If my count of records from input file is zero then i want to disable the container which have output tool. Can any one help me to achieve this?

[TheOC]

hey @RavitejaBaratam 

Heres a community post showing how you can disable or enable containers using condition tools.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Dynamically-enabling-disabling-work...

Slightly easier to use, would be the detour tool:

https://help.alteryx.com/current/designer/detour-tool

Hope this helps!
TheOC

[RavitejaBaratam]

HI Mate,

I am new to alteryx, Can you give me an example. my case is if my input file have 0 records then i dont want to write into output tool.  Just it need stop there. 

[TheOC]

hey bud,

No problem! I now understand your issue. I've actually done something similar before, following this guide:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Stop-workflow-on-a-condition/ta-p/1...

This is done through the test tool, but it is almost exactly your problem, test for if the data contains 0 records, and then stop the workflow.


I hope this helps,
TheOC

[Maskell_Rascal]

Hi @RavitejaBaratam 

If you have other processes that need to run in your workflow, you can use the Message tool to throw and error and stop processing downstream tools.

I've attached a sample workflow using this method. 

If you attach an Output tool to the end of the Formula Tools, you can see how it prevents the second workflow from writing to a workbook. 

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

Thanks!

Phil