Comparing Lists

Michael Hartman

Hey, so I have a data base table that has about 70 boolean values. How would I go about comparing two entries and returning a score of how many values match up. So if the first entry has lines 1,3,5,7, and 9 true and the second entry has lines 2,3,5,6,7, and, 9 true then I would get a return value of 4 because four of the line items have the same value.

Michael Hartman

Example, like in a dating app, I want to compare two lists of interests and only show data if two individuals have enough interests that match up.

Ray Deck

What a cool problem! I made a demo with a method that might save you some time: https://www.loom.com/share/e9c23764f3624f3cb4d2857f6a5dabc8 Let me know if it looks like it approximately fits your use case?

Michael Hartman

Yes that's perfect, thank you! I figured on using a loop and counter but I didn't know about the entries filter in Xano.