CODEWITHSUNDEEP
azureazure-data-factory
NikRED
NikRED

Reputation: 1195

Unable to filter an array using Azure ADF Filter Activity

I am trying to filter out one value from the array using a Set Variable & Filter activities, but i am not getting the filtered value in the filter activity output. Could you please guide me to make it work as expected?

1.Set Variable activity

enter image description here

2.Filter Activity

enter image description here

3.

Output { "ItemsCount": 1, "FilteredItemsCount": 0, "Value": [] }

Upvotes: 0

Views: 3000

Answers (1)

Steve Johnson
Steve Johnson

Reputation: 8660

You should set the Var variable like this: abc,def and the expression in the Filter activity should be like this:@equals(item(),'abc').

Screenshots:

enter image description here enter image description here enter image description here enter image description here enter image description here

Upvotes: 1

Related Questions