ADF Filter Activity Error with Expression....

Mike Kiser 1,526 Reputation points
2021-04-14T00:07:41.897+00:00

Hi! @Nasreen Akter @MartinJaffer-MSFT

I need to use a FILTER ACTIVITY with the following expression. I'm wanting to say if the first part in the parens are true and the item().classcode = 'EMP" is true.....

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

for the filter

But getting this error:
Warning
Expression of type: 'String' does not match the field: 'condition'

Please suggest...thanks! Mike Kiser

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,314 questions
No comments
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 24,091 Reputation points Microsoft Employee
    2021-04-14T02:27:41.673+00:00

    Hi again @Mike Kiser .

    Simple typo mistake. Move the @ in front of the and.

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

    because you had the @ between "and" and "contains", the whole thing started to look like a string. "andtrue" or "andfalse". The evaluation started after "and".


0 additional answers

Sort by: Most helpful