Forum Discussion
Iterative matching using weighting of multiple columns
I have to come up with an algorithm to find suitable matches for mentors and proteges. To simplify it (maybe), we have a table with employee id, role (mentor or protegee), 5 columns of answers to pr...
ImkeF
Community Champion
Community ChampionYou can do this in the query editor:
1) create a list with the profiles attributes for both
2) do a cartesian join, so that each item will be compared with all of the others.
3) For the comparison use List.Sum(List.Transform(List.Zip({protegeList, mentorList}), each Number.Abs(_{0}-_{1}))). That will add up all deviations