Run macro only on condition

[NidhiAg]

Hi Team,

I have a batch macro with 

1) Macro Input where I pass by Data

2) Control Parameter

Now I want to run this macro only if Data row count > 0 Else skip running macro

[atcodedog05]

Hi @NidhiAg 

Can you tell us what does that macro do ?

[ArtApa]

Hi @NidhiAg - 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/ 

However, similar questions have been asked on the Community and you may use this solution:

• https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Detour-Based-on-Condition/td-p/298792
• https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Detour-when-no-records-are-present/td-... 

[NidhiAg]

Thanks I will definitely look at Detour but u gave me idea of conditional container. I have done those so will be using this.

Thanks and Thanks to this awesome community. SO much to learn

[apathetichell]

just add a filter before you call the batch macro. Have the macro after the true end of the filter and filter by whatever you are counting >0... If you mean you want the macro to run - but not do anything @ArtApa 's links should help.