Answered

How to handle null data in Condition?

(0) Share

Report

Posted on by CW-23070243-0

I created a "Condition" to determine whether "customerId text" contains "txt" or is empty (sometimes AI builder can't get customerId from invoices). But it keeps showing the following error。

"customerId text" is from AI builder.

could you please help me with it ?

Thanks

Categories:

Business Process Flows

All responses (2)

Answers (1)

Chriddle 7,056 on at

Like (0)

Report

How to handle null data in Condition?

Just switch the order (first chek for null)
Verified answer

Mark Nanneman 329 on at

Like (2)

Report

How to handle null data in Condition?

To handle null errors in conditions like this, try using a coalesce function. Coalesce goes with the first object/value you give that isn't null.

coalesce(<your_string_input>,'')

If your input is a null, the coalesce will go with the '', which is technically not a null, and it can be checked by the condition for the substring, and it will return a false.