CODEWITHSUNDEEP
azureazure-data-factory
Dinesh Madhup
Dinesh Madhup

Reputation: 367

How to write Filter Expression in Azure Data Flow?

I have filter in Data Flow of Azure Data Factory where I need to write expression for the following SQL logic(Where statement):

Where 
ID NOT IN (Select PID from Table1 where ptype_c in (100, 2000))

Upvotes: 1

Views: 4886

Answers (1)

Steve Johnson
Steve Johnson

Reputation: 8660

If your source is SQL Database, you can just choose Query option. enter image description here

If no, you can try like this.

1.create a Filter activity, get the data which ptype_c is in (100, 2000). enter image description here

2.create a Select activity, change the column name. enter image description here

3.new a branch of Source. enter image description here

4.create a Exist activity. enter image description here

Upvotes: 6

Related Questions