Find similar by any value

Hi guys!
Could you please point me in the right direction?
I am building an app, that would display two characters from the movies with their positive and negative traits, and then below them, automatically would show the characters most similar to a combined traits of both characters.
So I display 5 positive traits of one character and 5 negative traits of another character, then if there is a character in the database, that has 6 or more traits out of those, I want to display the name of a similar character.
Can this be done at all?

Hi there, @Adam.NY… if I understand your post correctly, what you described can be done, and it would likely be done with an advanced filter that does a count of the intersect between two (or possibly three) lists. There are a good number of topics in the forum that discuss this type of filter, so do some searching and see what you can find.

Best…
Mike

1 Like

Thank you!

1 Like