Data Transformation Add Columns - Can I Have A Complex Equation?

Hi there @Teodor…

I want to use the new Add Column server action step to have a value like this:

{{(((validity_status=='d') && (valid_from <= local_time) && (valid_to >= local_time)) || (validity_status=='a'))?1:0}}

where validity_status, valid_from, valid_to are columns in the original database query, and local_time is a Set Value.

Is this possible to do right now?

If so, is this the right syntax to do it?

Best wishes,
Antony.