Disable part of workflow if no filter returns False

[fardeen9983]

I have a workflow where I am trying to get only row as output. The issues I have are as follows:

1. The container runs the Input macro even if the Filter has no True records

2. In the browse tool for the union you can see I have two records as output. What I want is for them to merge into one record with the 2nd row overwriting the 1st one if it is not null

Thanks for your time

[morr-co · Accepted solution]

Hi @fardeen9983 - my recommendation would be to update the macro to accept a record count parameter and to use that parameter to update a detour tool. This would bypass all of the tools if there is no incoming data. I've attached an example of what this might look like. The formula in the action tool is shown below and should update the DetourRight configuration.

IIF(ToNumber([#1]) = 0, "True", "False")

[hemant86]

Hi @fardeen9983 Appreciate if you could attach the workflow