Need to Combine 3 filters into 1 .....please assist

asked 2021-04-14T18:38:01.067+00:00
Mike Kiser 1,526 Reputation points

Hello! @Nasreen Akter @MartinJaffer-MSFT

Since I need a filtered input to my ForEach, I need to combine 3 filters into one to use as input to my ForEach. I have tried but this take a master of expressions.....Please help me combine the following 3 filters into one:

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

filter
@contains(createArray('BCO','BED','BSC','BNB'),item().company)

Filter
@hamed1374 (contains(item().status,'Inactive'))

I have tried and tried but can not produce only one Filter Criteria...

Thanks again!!
Mike Kiser

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

Accepted answer
  1. answered 2021-04-14T18:44:10.867+00:00
    Nasreen Akter 10,601 Reputation points

    Hi @Mike Kiser ,

    You can try the following expression. Hope this helps. Thanks!

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

0 additional answers

Sort by: Most helpful