如何根据值在Azure数据工厂中复制数据? [英] How to copy data in Azure Data Factory depending on the values?

问题描述

我的问题是这样的: 例如，我在SQL Server table1(id，number1，number2)和其他table2(id，finalNumber)中有一个包含三列的表.如何进行条件复制?我想复制table2(finalNumber)中每一行的较大数目.我想到了LookUp-> IfConditionally，但是它不起作用.

my problem is this: For example, I have a table with three columns in SQL Server table1(id, number1, number2) and other table2(id,finalNumber). How can I do a conditional copy? I want to copy the bigger number of each row in the table2(finalNumber). I thought a LookUp->IfConditionally but it doesn't work.

推荐答案

从如果条件满足，请在Azure数据工厂中引用JSON有效负载值

From the example in the IfCondition activity document,it could be used to quote the output data from look up activities.Like @{activity('MyLookupActivity').output.firstRow.count}. You could refer to my previous case:Referencing JSON payload value in Azure Data Factory for If condition

此外，还有一个想法是使用存储过程.您可以链接，以在您的

In addition,one more idea is using stored procedure.You could this link to configure sql server stored procedure in your sql server sink.

然后您可以将数据从源表复制到临时表.并进行数字对比业务并在存储过程中插入操作.在上一案例中，我做了非常详细的步骤:Azure Data Factory在同一列中映射2列请参阅它.

Then you could copy the data from source table to the temporary table.And do the number contrast business and insert operations in the stored procedure.There are very detailed steps i did in my previous case: Azure Data Factory mapping 2 columns in one column refer to it.

任何关心，让我知道.

这篇关于如何根据值在Azure数据工厂中复制数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！