Azure数据工厂-复杂Json数据转换

Question

我希望使用ADF将json blob数据转换为关系格式，如下所示:

"reseller": {
"en-ca": [
{
"MarketPlaceResellerId": "1",
"ResellerPrice": "",
"ResellerFormattedPrice": "",
"InventoryStatus": 3
}
],
"en-us": [
{
"MarketPlaceResellerId": "2",
"ResellerPrice": "",
"ResellerFormattedPrice": "",
"InventoryStatus": 4
}
],
"fr-ca": [
{
"MarketPlaceResellerId": "1",
"ResellerPrice": "",
"ResellerFormattedPrice": "",
"InventoryStatus": 3
}
Output :

Market      MarketPlaceResellerId   ResellerPrice   ResellerFormattedPrice  InventoryStatus 
En-ca                  1               3 
En-us                  2               4 

可以使用的转换ADF是什么?

Answer 1

使用名为"扁平化"的ADF数据流转换;对于每个数组