hi all, I think the xmas break may have dissolved my Appian knowledg

hi all,

I think the xmas break may have dissolved my Appian knowledge; I can't seem to use the filter function anymore.
I'm trying to filter a text array, with value from a different text array. Sounds simple, but i can't get it to work.

For instance, to filter the values from array {mouse;dog;monkey;cat} that equal any item in the array {dog;cat} I'm trying to use the filter function:
=filter(fn!like,pv!allAnimals,ri!animalsToKeep)

This function however returns only the dog.

(note, in real life the first array here is a CDT, and i'll be filtering on only one (text) element of this cdt)

Do you guys have any idea what i'm doing wrong?
Thanks :)...

OriginalPostID-94692

OriginalPostID-94692