Filter Tool No Records - Formula Tool Fais

Kristie_Pires

Hi everybody,

I've noticed that when the filter tool gives me zero records, the formula tool fails to work. I get the following error: "Parse error at char (11): unknown variable "Amt_Requested".

Is there a tool that can stop that section of the workflow from running if I get zero records after the filter tool?

Thank you so much for helping me out!

atcodedog05

Hi @Kristie_Pires 

As you mentioned that columns might be missing sometimes and as @apathetichell & @danilang mentioned this issue is being caused by missing columns referenced in the formula.

What you can do in this scenario is something like below

Input Data: Lets say input data doesn't have amt_requested column

amt requested

100

300

Workflow: You can design your workflow like below. You can have one text input tool with the all the required headers we will union that with the data. What this does is even though column is not present in input data the headers will add the all-required column. This way your formula should still be intact and not cause errors. Refer below ran with no errors.

Hope this helps : )

Missing Headers.yxmd