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 itemDictionaryname: "test Info Process"id_txt: "BPITM84"
Can anyone please guide me in this?
Thanks in advance.
Discussion posts and replies are publicly visible
Use flatten for your input dictinoaries ...I have tested .. This works fine with the below code
a!forEach( items: a!flatten(local!x), expression: { if(contains(a!flatten(local!y),fv!item),{},{fv!item}) } )