If then else and columnexists()

1

Hi,

Within a Calculate new column action, I have a code looking like this within expression editor:

if columnexists("A_FIELD") then
(
if istextdate([A_FIELD]) then
date([A_FIELD])
else
error("Cannot convert to date")
)
else
error("Column does not exist")

However, it looks like even if condition is never met, code inside first part is always interpreted, and actions fails with error "Column [A_FIELD] not found". Any idea ?

Thanks and regards

2

Hi @David_Juras,

Please take a look at the proposed solution for a similar question here.
The latest release already supports lazy evaluation in Rule action, as mentioned in the linked post.

Thanks

3

Hi, thanks a lot guys !