Activate/Deactivate Tools/Paths based on condition

[verast23]

Hi Community,

I have a FilterTool at the beginning of my workflow, which checks if certain data is present in my data set. Depending on the quarter, the complete data set is output as "True" or as "False".

E.g. in quarter 1 a True output is given and accordingly the adjustments are made with different tools. The False output then contains no data. This works also Vice Verca.
I am now looking for a way to disable the tools that come after the False Output, for example, if the False Output does not contain any data, so only calculations with the True Output should be made.
This should then also work Vice Verca, if I have no True Output these tools should be deactivated and only the tools after the False Output should run and write output.

I hope someone coul dhelp me with this issue!

[afv2688]

Hello @verast23 ,

How about this solution? It decides based on the record count.

Regards

[verast23]

Hi @afv2688 ,

thanks for your Solution. 
I am trying to implement it, but I have one more question. 
So the tools which follow the true or false data, give me 3 different conditional Excel Outputs. So I don't know where to set the output Macro Tool.

[afv2688]

All the logic needs to be implemented within the macro on the containers. The upper one is the one used for the Condition = 1 while the one on the bottom is used for the condition = 0

The macro basically forces the container to be disabled to avoid the process to be executed.

I just added a formula which does insert a string with different values depending on the process, in the end both results or logics are then merged, given that there will be no data always on one side there will just one side with output.

Regards

[verast23]

I understand how the macro works. It' s just not clear to me how to configure the Input and Output Macro Tools. E.g. in the Input Tool the input of the "True" or "False" data should be taken. However, I always get an error message and the macro does not run.