CODEWITHSUNDEEP
azureazure-data-factoryazure-synapse
Bob
Bob

Reputation: 661

How can I filter on a list in Azure Synapse filter transformation mapping data flow

In Azure Synapse Data flows I want to filter on a list of values.

I can use the following syntax:-

column1 == 'A' || column1 =='B'

but would like to use something like this:-

column1 IN ('A','B')

How can I do that?

enter image description here

Upvotes: 2

Views: 1449

Answers (1)

Steve Johnson
Steve Johnson

Reputation: 8660

This expression column1 IN ('A','B') can't work. Instead,you can build an array and then use this expression:

in(['A','B'],column1)

Reference:https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions#in

Upvotes: 5

Related Questions