Dataweave filtering array by another array values

Question

I would like to filter an array based on another array values. I would like to filter the input array based on key value "KNVP-PARVW" is in the list of ["BP,SH,PY"]

here is the input:

[{
    "KNVP-KUNNR": "100098",
    "KNVP-VTWEG": "A1",
    "KNVP-PARVW": "BP",
    "KNVP-PARZA": "000",
    "KNVP-KUNN2": "200115",
    "KNVP-DEFPA": ""
  },
  {
    "KNVP-KUNNR": "100098",
    "KNVP-VTWEG": "A1",
    "KNVP-PARVW": "SH",
    "KNVP-PARZA": "001",
    "KNVP-KUNN2": "200115",
    "KNVP-DEFPA": ""
  },
  {
    "KNVP-KUNNR": "100098",
    "KNVP-VTWEG": "A1",
    "KNVP-PARVW": "ZR",
    "KNVP-PARZA": "000",
    "KNVP-KUNN2": "256",
    "KNVP-DEFPA": ""
  }]

and here is my dataweave code:

%dw 2.0
var relationList=["BP,SH,PY"]
output application/json
---
payload filter (  relationList contains  $."KNVP-PARVW" )

aled · Accepted Answer · 2020-07-23 02:33:22Z

4

While ["BP,SH,PY"] is a list, it has only one element which is a string. To use contains() as you intend, it has to be a list of the valid values for $."KNVP-PARVW":

%dw 2.0
var relationList=["BP","SH","PY"]
output application/json
---
payload filter (  relationList contains  $."KNVP-PARVW" )

Output:

[
  {
    "KNVP-KUNNR": "100098",
    "KNVP-VTWEG": "A1",
    "KNVP-PARVW": "BP",
    "KNVP-PARZA": "000",
    "KNVP-KUNN2": "200115",
    "KNVP-DEFPA": ""
  },
  {
    "KNVP-KUNNR": "100098",
    "KNVP-VTWEG": "A1",
    "KNVP-PARVW": "SH",
    "KNVP-PARZA": "001",
    "KNVP-KUNN2": "200115",
    "KNVP-DEFPA": ""
  }
]

answered Jul 23, 2020 at 2:33

aled

26.5k4 gold badges36 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Learner · Accepted Answer · 2020-07-23 00:22:48Z

-1

Got it the var relationList should be like below

var relationList="BP,SH,PY"

answered Jul 23, 2020 at 0:22

Learner

1595 silver badges23 bronze badges

1 Comment

aled Over a year ago

That is a bad solution. You are using contains() with a string, so if $."KNVP-PARVW" == "P,S" then it would be true because it is a valid substring of relationList.

Collectives™ on Stack Overflow

Dataweave filtering array by another array values

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related