如何在ADF中将两个JSON文件合并为一个

Question

我有两个生成并存储在blob中的JSON文件。JSON文件是通过ADF生成的。我的客户希望将文件生成为单个文件。下面是生成的两个JSON文件。

文件1:

{
"CustomerGroups": [
"XX"
],
"DebtorCodes": [],
"Materials": [
{
"ArticleCode": "44512777",
"ColorOverrule": "null",
"DescriptionOverrule": "null",
"PromotionPrice": null,
"SalePrice": 72.0
},
{
"ArticleCode": "44583888",
"ColorOverrule": "null",
"DescriptionOverrule": "null",
"PromotionPrice": null,
"SalePrice": 169.0
}
],
"Name": "Pricelist XX"
},

文件2:

{
"CustomerGroups": [
"YY"
],
"DebtorCodes": [],
"Materials": [
{
"ArticleCode": "44512344",
"ColorOverrule": "null",
"DescriptionOverrule": "null",
"PromotionPrice": null,
"SalePrice": 72.0
},
{
"ArticleCode": "44583455",
"ColorOverrule": "null",
"DescriptionOverrule": "null",
"PromotionPrice": null,
"SalePrice": 169.0
}
],
"Name": "Pricelist YY"
},

JSON中预期的输出：

[
{
"CustomerGroups": [
"XX"
],
"DebtorCodes": [],
"Materials": [
{
"ArticleCode": "44512777",
"ColorOverrule": "null",
"DescriptionOverrule": "null",
"PromotionPrice": null,
"SalePrice": 72.0
},
{
"ArticleCode": "44583888",
"ColorOverrule": "null",
"DescriptionOverrule": "null",
"PromotionPrice": null,
"SalePrice": 169.0
}
],
"Name": "Pricelist XX"
},
{
"CustomerGroups": [
"YY"
],
"DebtorCodes": [],
"Materials": [
{
"ArticleCode": "44512344",
"ColorOverrule": "null",
"DescriptionOverrule": "null",
"PromotionPrice": null,
"SalePrice": 72.0
},
{
"ArticleCode": "44583455",
"ColorOverrule": "null",
"DescriptionOverrule": "null",
"PromotionPrice": null,
"SalePrice": 169.0
}
],
"Name": "Pricelist YY"
},
]

Answer 1

复制数据可以用于合并文件，前提是我们使用前缀，并且文件应该在同一文件夹中。