HELP. Quick Turn. How do I ignore segment of workflow if no records are present.

HELP.

See image below. Note error marker on formula. This is part of an macro/app. I found 1 of 35 documents does not contain quantities so no records are passed -- which creates the error.

How do I get the workflow to bypass this string if there are no records going to it?????

I tried add a count tool and then a filter set to count does not equal 0. But that does not work.

Macros

Help

Accepted answers

hellyars

This is a bit mental...

...I came up with a band-aid...

After count + filter ....

True passes no records...(meaning no records)...passes no records to the formula tool and creates an error.

So, I took the false record (count = 0) added an ensure fields (to sum in formula tool) that passes dummy data (filled with zeros) to the formula tool to avoid error message

Ugh...there has to be a simpler way to do this...

soccertil1108

I haven't seen a response from you so I took some time and created a macro that skips a formula if there are no records. Check out the attached workflow and macro.

skipFormula2.yxmd

skipFormula macro.yxmc

All comments

hellyars

One more thing.... reference image of workflow....

The first filter after the parse is do not pass if Quantity is null... it passes no records to the rest of the snipped ...and then hits my count / zero filter ....yet it still hits the formula with no records and errors causing my app to fail.

hellyars

This is a bit mental...

...I came up with a band-aid...

After count + filter ....

True passes no records...(meaning no records)...passes no records to the formula tool and creates an error.

So, I took the false record (count = 0) added an ensure fields (to sum in formula tool) that passes dummy data (filled with zeros) to the formula tool to avoid error message

Ugh...there has to be a simpler way to do this...

soccertil1108

without getting into detailed solution to your problem. How about this quick idea? You can create a marco that has two branchs for the input stream and then a Union at the end. Put the two branches in separate Tool Containers. Pass a count of records into the macro as a parameter. If the count is Zero disable the first container, if not disable the second container. reach out of you have additional questions or can provide detailed data and workflow.

skipFormula.yxmd

soccertil1108

I haven't seen a response from you so I took some time and created a macro that skips a formula if there are no records. Check out the attached workflow and macro.

skipFormula2.yxmd

skipFormula macro.yxmc

hellyars

@soccertil1108 Thanks. Just came up for air. Will take a look.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703