Using CONTAINS() function in Azure Data Factory Dataflow - Stack Overflow

admin管理员组

文章数量:1345083

I used the contains() and filter() array for the first time in Filter Activity of ADF dataflow and tried to find the type.code equals to 'Y' or equals 'lib'. But it didn't work. Not sure what was wrong. I appreciate any support can help me understand this.

contains(record.Organizations.authorOrganization.type,#item.code == 'Y')
|| filter(,#item == 'lib')

sampleJson:

{
   "record":
   {
      "Organizations": {
           "authorOrganization": [
             {
                "num": "1",
                "city": "CHICAGO",
                "name": "",
                "type": {
                    "code": "Y"
                 }
             }
           ]
       }
   },
  "":["lib","dab","wsa"]
} 

I used the contains() and filter() array for the first time in Filter Activity of ADF dataflow and tried to find the type.code equals to 'Y' or equals 'lib'. But it didn't work. Not sure what was wrong. I appreciate any support can help me understand this.

contains(record.Organizations.authorOrganization.type,#item.code == 'Y')
|| filter(,#item == 'lib')

sampleJson:

{
   "record":
   {
      "Organizations": {
           "authorOrganization": [
             {
                "num": "1",
                "city": "CHICAGO",
                "name": "",
                "type": {
                    "code": "Y"
                 }
             }
           ]
       }
   },
  "":["lib","dab","wsa"]
} 

• azure-data-factory

Share Improve this question Follow edited 20 hours ago thichxai asked 21 hours ago thichxaithichxai 1,14711 gold badge88 silver badges1717 bronze badges 2

• Can you provide your expected data for it? – Rakesh Govindula Commented 20 hours ago
• if conditions are match then return entire json files. – thichxai Commented 20 hours ago

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 0

var results = record.Organizations.authorOrganization.type.code contains('Y')

You can modify your expression like below to achieve your requirement.

contains(record.Organizations.authorOrganization,#item.type.code=='Y') || contains(,#item=='lib')

Here as the authorOrganization is an array, you need to give it in the contains() expression and give the condition for the objects within that array.

It will give the expected results as shown below.

本文标签： Using CONTAINS() function in Azure Data Factory DataflowStack Overflow