ADF Expression @lessorequals question?

Mike Kiser 1,531 Reputation points
2021-05-21T15:19:53.427+00:00

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?

Thanks!
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
    2021-05-21T15:54:05.687+00:00

    Hey,
    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?

    Solution:

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