Disable Container if there is no record in the stream

Question

Hi Alteryxians,

Just wondering if anyone has idea on how to disable container if there is no data in the stream/flow?

Some people suggested to utilize Count Record Tool to create a record of 0, and then use Action task based tools to dynamically disable container if value is 0.

From what I understand, it seems that interface tools are needed to achieve this.

As I am not familiar with interface tools, is anyone willing to build a mock up or sample flow in this post?

Thank you very much!

apathetichell · Answer

you can feed in count via batch macro and have the optionality set in the formula config of action tool to enable/disable container.

JingZuo · Answer

Hi I'm facing the same issue. the conditional routing lesson is based on Radio button which requires user to choose. what I need is to dynamically enable/disable based on count of record. If record count is zero, then disable container A. If record count isn't zero, then disable container B. Any suggestions will be appreciated.

ArtApa · Answer

Hi @owenkosnen - You can implement conditional routing in a couple of ways in Alteryx. If you're keen to use containers, please review the following interactive lesson: https://community.alteryx.com/t5/Interactive-Lessons/Implementing-Conditional-Routing/ta-p/243117

Also, you may want to explore the Detour Tool, which can be a good alternative to Disabling Containers: https://www.thedataschool.co.uk/gregg-rimmer/using-detour-tool-alteryx/