如何在映射中比较2个不同的表列值 [英] how to compare 2 differnt tables column values in mapping

问题描述

大家好，

我是BizTalk的新手。我需要根据以下条件映射输入字段，并将值插入到DB表中。

I am totally new to BizTalk. I need to map input fields based on the below conditions and insert the values into DB tables.

条件1;

*******

示例输入 - > input1，input2，Input3

sample Input--> input1,input2,Input3

如果input1 ='111'然后将input2映射到table1.coloum2然后从table1.column1获取值。

if input1 = '111' then map input2 to table1.coloum2 then fetch the value from table1.column1 .

然后将获取的值插入table2.column8

then insert the fetched value into table2.column8

condition2：

condition2:

********

如果inout3 ='56'则更新值"56FG"。 table4.column4 = table5.column5

if inout3 ='56' then update the value "56FG" into table3.column3 when table4.column4 = table5.column5

推荐答案

我建议您编写一个存储过程来为您处理插入逻辑。这是由于使用了不同的表格，需要将插入的表格中的生成值插入另一个表格。

I propose that you write a stored procedure to handle the insert logic for you. This is due to the different tables used coupled with the need to insert a generated value from the inserted table to another.

你只需要调用它来自BizTalk的SP，带有所需的参数，让程序处理插入/选择。

You simply call this SP from BizTalk with the parameters needed and let the procedure handle the inserts/selects.

如果这不是一个选项，你当然可以从BizTalk处理它，但恕我直言它也会产生如果您有可能创建存储过程，那么复杂性是值得的。

If this is NOT an option, you can of course handle it from BizTalk, but IMHO it would generate too much complexity to be worth it if you have the possibility of creating a stored procedure instead.

这篇关于如何在映射中比较2个不同的表列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！