最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

azure data factory - ADF filter transformation - Stack Overflow

programmeradmin5浏览0评论

My filter requirement (contains(record.Distribution,#item.code != 'AM')) However, I encountered the issue of the filter returning a document that an array Distributed object with multiple codes in example 2.json. Is that because an array Distribution object has multiple codes? How can I fix the logic not to return 2.json?

For examples:

1.json
{
  "record":{
   "Distribution":[
       "code": "AM",
       "Desc": ""
   ]
  }
}

2.json
{
  "record":{ 
  "Distribution":[
       {
         "code": "XD",
         "Desc": ""
       },
       {
         "code": "AM",
         "Desc": ""
       }
   ]
  }
}
发布评论

评论列表(0)

  1. 暂无评论