映射数据流转换概述Mapping data flow transformation overview

适用于: Azure 数据工厂 Azure Synapse Analytics

下面是映射数据流中当前受支持的转换的列表。Below is a list of the transformations currently supported in mapping data flow. 你可以单击每个转换,了解其配置详细信息。Click on each transformations to learn its configuration details.

名称Name 类别Category 说明Description
聚合Aggregate 架构修饰符Schema modifier 定义不同类型的聚合,如 SUM、MIN、MAX 和 COUNT,并按现有或计算列进行分组。Define different types of aggregations such as SUM, MIN, MAX, and COUNT grouped by existing or computed columns.
更改行Alter row 行修饰符Row modifier 对行设置插入、删除、更新和更新插入策略。Set insert, delete, update, and upsert policies on rows.
有条件拆分Conditional split 多个输入/输出Multiple inputs/outputs 根据匹配条件将数据行路由到不同的流。Route rows of data to different streams based on matching conditions.
派生列Derived column 架构修饰符Schema modifier 使用数据流表达式语言生成新列或修改现有字段。generate new columns or modify existing fields using the data flow expression language.
ExistsExists 多个输入/输出Multiple inputs/outputs 检查数据是否存在于另一个源或流中。Check whether your data exists in another source or stream.
FilterFilter 行修饰符Row modifier 基于条件筛选行。Filter a row based upon a condition.
平展Flatten 架构修饰符Schema modifier 获取层次结构(如 JSON)中的数组值,并将其展开到各个行。Take array values inside hierarchical structures such as JSON and unroll them into individual rows.
JoinJoin 多个输入/输出Multiple inputs/outputs 合并两个源或流中的数据。Combine data from two sources or streams.
查找Lookup 多个输入/输出Multiple inputs/outputs 引用来自其他源的数据。Reference data from another source.
新建分支New branch 多个输入/输出Multiple inputs/outputs 对同一数据流应用多组操作和转换。Apply multiple sets of operations and transformations against the same data stream.
ParseParse 格式化程序Formatter 分析数据流中的文本列(是 JSON 字符串、带分隔符的文本或 XML 格式文本)。Parse text columns in your data stream that are strings of JSON, delimited text, or XML formatted text.
透视表Pivot 架构修饰符Schema modifier 一种聚合,其中一个或多个分组列将其不同的行值转换到各个列中。An aggregation where one or more grouping columns has its distinct row values transformed into individual columns.
RankRank 架构修饰符Schema modifier 根据排序条件生成已排序的排名Generate an ordered ranking based upon sort conditions
SelectSelect 架构修饰符Schema modifier 别名列和流名称,以及删除或重新排序列Alias columns and stream names, and drop or reorder columns
接收器Sink - 数据的最终目标A final destination for your data
SortSort 行修饰符Row modifier 对当前数据流中的传入行进行排序Sort incoming rows on the current data stream
SourceSource - 数据流的数据源A data source for the data flow
代理键Surrogate key 架构修饰符Schema modifier 添加增量非业务任意密钥值Add an incrementing non-business arbitrary key value
联合Union 多个输入/输出Multiple inputs/outputs 垂直合并多个数据流Combine multiple data streams vertically
逆透视Unpivot 架构修饰符Schema modifier 将列透视为行值Pivot columns into row values
窗口Window 架构修饰符Schema modifier 定义数据流中基于窗口的列聚合。Define window-based aggregations of columns in your data streams.
ParseParse 架构修饰符Schema modifier 将列数据分析为 Json 或带分隔符的文本Parse column data to Json or delimited text