Forum Academy Marketplace Showcase Pricing Features

Matching fields with intersect and ranking

Hi there
I’m trying to add a ranking to my advanced intersect statement but I have no clue how to do it.

I compare the list values of two fields of each user in the user table. It works fine.
But the question is, how can I rank the search results (users) by the number of matches?
For instance:

dictCanonDiagnoses: ValD1, ValD2, ValD3
dictCanonMedications: ValM1, ValM2, ValM3

dictCanonDiagnoses: ValD3
dictCanonMedications: ValM1

dictCanonDiagnoses: ValD2, ValD3
dictCanonMedications: ValM1, ValM2

USER B should be at the top of the list.

Thank you for your help!

Here is my statement:

Hey @marco.mueller,
i have the same problem, did you figure it out in the meantime?

@marco.mueller @Juli same here, did you find any solution yet?

I solved it with ‘ranked by’ and selected ‘numerical similarity to …’