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
By writing a query first get that three lists to Appian environment from Database then write this expression,
a!localVariables( local!list1: {"IT", "UK", "DZ", "USA"}, local!list2: {"DZ", "USA"}, local!list3: {"IT", "UK", "DZ"},
intersection(local!list1,local!list2,local!list3))