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
Hi cugino95 ,
The below code might help you
a!localVariables( local!list1: {"IT", "UK", "DZ", "USA"}, local!list2: {"DZ", "USA"}, local!list3: {"IT", "UK", "DZ"}, local!intersection1:intersection(local!list1,local!list2), local!intersection2:intersection(local!intersection1,local!list3), local!intersection2 )