Azure数据工厂:对于特定属性，对于每个item()值都不存在 [英] Azure Data Factory: For each item() value does not exist for a particular attribute

问题描述

对于每个具有存储过程(SP)的活动，我都有一个，其中我显然是使用item()输入值的.

I have a for each activity which has a stored procedure (SP) wherein I am inputing values using item() evidently.

现在假设SP的输入值为item().a，item().b和item().c

Now suppose SP's input values are item().a, item().b and item().c

问题:对于foreach的某些迭代，不存在预期的item().b.那么我应该如何在存储过程中处理它呢?因为在这一点上，它在执行SP时通过说:

Question: For some of the iteration of foreach, item().b does not exist which is expected. So how should i deal with it in the Stored procedure? Because at this point of time it is giving me an error when it executed SP by saying:

无法评估模板语言表达式'item().b'，因为属性'b'不 存在，可用属性为"a，c"

"The template language expression 'item().b' cannot be evaluated because property 'b' doesn't exist, available properties are 'a, c'

或者我该如何克服数据工厂中的这种故障?

or how should I overcome this failure in the data factory?

显然，数据工厂具有检查empty()的功能，但不具有检查exist()的功能.

Apparently, data factory has the check for empty() but it does not have the check for exist().

推荐答案

您可以使用?".即item()?. b

You could use "?". I.e., item()?.b

请参考问号和相关的帖子.

这篇关于Azure数据工厂:对于特定属性，对于每个item()值都不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！