如何在Azure数据流中编写过滤器表达式? [英] How to write Filter Expression in Azure Data Flow?

问题描述

我在Azure数据工厂的数据流中有过滤器，我需要为以下SQL逻辑(Where语句)编写表达式:

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

推荐答案

如果源是SQL数据库，则只需选择查询"选项.

If your source is SQL Database, you can just choose Query option.

如果没有，您可以尝试这样.

If no, you can try like this.

1.创建一个Filter活动，获取ptype_c所在的数据(100、2000).

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

2.创建一个Select活动，更改列名.

2.create a Select activity, change the column name.

3.new Source的一个分支.

3.new a branch of Source.

4.创建一个现有活动.

4.create a Exist activity.

这篇关于如何在Azure数据流中编写过滤器表达式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！