Couldnt compare 2 list of dictionaries

Hi All,

 I have a requirement where i do have 2 list of dictionaries(X,Y). So im iterating the first one X and comparing whether its value is present in the Second one Y,if not present then i should get the value.Eventhough ,the value is present in Y,getting not found.

local!x:{
a!forEach(
items:local!getAllActiveIncompleteObservations,
expression: {
name:fv!item.name,
id_txt:fv!item.id_txt,
}
)
},

local!y:{
a!forEach(
items:ri!currentReviewObser_cdt,
expression: {
name:fv!item.name,
id_txt:fv!item.id_txt,
}
)
},

local!z:
{
a!forEach(
items: local!x,
expression: {
if(contains(local!y,fv!item),{},{fv!item})
}
)
},


output: x

List of Dictionary: 4 items
Dictionary
name: "test Info Process"
id_txt: "BPITM51"
Dictionary
name: "test_exampleProcessModel"
id_txt: "BPITM51"
Dictionary
name: "test Info Process"
id_txt: "BPITM84"
Dictionary
name: "test_exampleProcessModel"
id_txt: "BPITM84"

output : y
List of Dictionary: 3 items
Dictionary
name: "test Info Process"
id_txt: "BPITM51"
Dictionary
name: "test_exampleProcessModel"
id_txt: "BPITM51"
Dictionary
name: "test_exampleProcessModel"
id_txt: "BPITM84"

output :z

List of Variant: 4 items
List of Dictionary: 1 item
Dictionary
name: "test Info Process"
id_txt: "BPITM51"
List of Dictionary: 1 item
Dictionary
name: "test_exampleProcessModel"
id_txt: "BPITM51"
List of Dictionary: 1 item
Dictionary
name: "test Info Process"
id_txt: "BPITM84"
List of Dictionary: 1 item
Dictionary
name: "test_exampleProcessModel"
id_txt: "BPITM84"

Expect the output to be something like this.

List of Dictionary: 1 item
Dictionary
name: "test Info Process"
id_txt: "BPITM84"

Can anyone please guide me in this?

Thanks in advance.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data