question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

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

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
@and(contains(createArray('BCO','BED','BSC','BNB'),item().company), equals(item().classcode,'EMP'))

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

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

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

Thanks again!!
Mike Kiser

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

nasreen-akter avatar image
0 Votes"
nasreen-akter answered ewinkiser commented

Hi @ewinkiser,

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')))

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @nasreen-akter
That worked great!!! PLEASE write a book on advanced expressions :-)! MS Docs have such simple expression examples it doesn't really help.

Thanks again! Now I can put this back into QA Testing!!!

Mike Kiser

1 Vote 1 ·