Hi,
"I have three lists and I need to obtain the values present in all three lists? How can I do this without having to perform an inner join on the database?"
ex. list1: {"IT","UK,"DZ", "USA"}
list2: {"DZ", "USA"}
list3: {"IT","UK,"DZ"}
and I need to obtain {"DZ"}
thanksss
Discussion posts and replies are publicly visible
This code may help you
a!localVariables( local!list1: {"IT", "UK", "DZ", "USA"}, local!list2: {"DZ", "USA"}, local!list3: {"IT", "UK", "DZ"},
a!forEach( items: local!list1, expression: if( and(contains(local!list2, fv!item), contains(local!list3, fv!item)), fv!item, {} ) ))