ADF : check on null values in array

Question

Hi

we have an incoming array called STG_LogicalKey in our ADF data flow.
In a filter activity we want to filter out those rows in the array where one, or all of the elements contain a NULL value

As filter condition we are using:
not(isNull(byNames($STG_LogicalKey)))

This works if the array contains one element.
But if the array contains 2 or 3 elements , we get an error saying: "function doesn't support 2 (or 3) arguments"

What is the expression to check if the array contains an element with a NULL value?
What is the expression to check if all the elements of the array contain a NULL value?

Regards
Ron

Answer 1

You should look at array functions for this in the expression guide: https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions#array-functions

Something like this is what you'll use: filter(array,!isNull(#item))

Answer 2

thnx @MarkKromer-MSFT

we used iif(contains(array(byNames($STG_LogicalKey)),isNull(#item)),'Y','N'), but your proposal works as well

thnx