CODEWITHSUNDEEP
azure-data-factory
Mike Kiser
Mike Kiser

Reputation: 33

ADF Expression @and?

I am having issues with the following ADF Expression in my Filter Activity.

and(@contains(createArray('BCO','BED','BSC','BNB'),item().company), equals(item().classcode,'EMP'))

I am getting the following warning: Warning Expression of type: 'String' does not match the field: 'condition'

Can anyone assist? THanks Mike

Upvotes: 0

Views: 1110

Answers (1)

Leon Yue
Leon Yue

Reputation: 16401

Like the error said the first and condition @contains(createArray('BCO','BED','BSC','BNB'),item().company isn't a condition expression and doesn't return a true or false, It's s Sting.

Your filter expression should like this:

@and(contains(createArray('BCO','BED','BSC','BNB'),item().company), equals(item().classcode,'EMP'))

Ref: and.

HTH.

Upvotes: 1

Related Questions