Enable Disable Container based on record

Hi All,

When uploading to Gallery, we’re trying to prevent a "Character Parse" error in Formula (3) when no records are available for parsing. Currently, the workflow correctly displays a "No Records" message, but the Formula tool still triggers a Character Parse error. Please note that we have intentionally left the text input blank to simulate our intended scenario where no rows are available.

One approach we're exploring is to dynamically disable or enable the Control Container based on the Record Count to prevent the formula from executing unnecessarily. However, we haven’t yet figured out how to implement this. Any suggestions or guidance would be appreciated.

Gallery Error.yxmd

Workflow

Reporting

Regex

Output

Parse

Dynamic Processing

Preparation

Data Investigation

Database Connection

Iterative Macro

Accepted answers

caltang

@Labhesh let me introduce you to a new way of doing it rather than using a control container:

Introducing DETOURS! If they fulfil your criteria, it triggers the path to proceed to the formula or not. Use this logic and concept to get what you want.

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Gallery Error.yxzp

All comments

TheOC

hey @Labhesh ,
If you are trying to a numeric formula on column 'A', you can get around your formula tool creating errors by changing your formula to:

Or:
Changing your data type in the select tool to a numeric type:

The reason this works is that when the text input doesn't have any data for a field, it assumes it is text data (string). The formula you have created will error with a string as you cannot add a numeric (10) to a string. The reason both of these fixes work, is they force the formula to recognise the column as a number, either by changing it prior to the formula in the select tool, or changing it within the formula with the ToNumber expression.

I suspect this is a nicer route for you than forcing the control container to stop running the formula if no records are received. Let me know if I have misunderstood your scenario however.

caltang

@Labhesh let me introduce you to a new way of doing it rather than using a control container:

Introducing DETOURS! If they fulfil your criteria, it triggers the path to proceed to the formula or not. Use this logic and concept to get what you want.

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Gallery Error.yxzp

Labhesh

@CA Thank you for your support It worked

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703