ADF Expression @lessorequals question?

Mike Kiser 1,531 Reputation points

Hi @Nasreen Akter

I have the expression in my If Condition:

@lessorequals(int(item().virtualWorkPercentage), 0)

Without notice, I found out that the 0 can also be a NULL; how can I handle both?

Mike Kiser

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,110 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 29,471 Reputation points MVP

    You can use the below expression
    equals(coalesce(item(). Virtualworkpercantage, ' '), ' ') to check whether the value is null and based on your requirement do the needful in your if condition. Is your ask to make null values as zero?


    @lessorequals(int(coalesce(item().virtualWorkPercentage,0)), 0)