Finding Duplicate Values in Lookup Arrays

Hi everyone, new to Glide!

Is there a way to find duplicate values between two columns that consist of arrays (retrieved from lookups)? In the example below, I’d love to create a new column that shows this data. For each row, the only value would be “Exercise & Fitness”.

Thanks for any help!

What you can do is take your first lookup and use it to create a second relation to your data. That way you will use your array of Liker Hobbies in a relation to any matching rows in a Likee relation.

You can’t compare two arrays like you’re asking. You have to use the Relation → Lookup → Relation → Lookup method. Hope that makes sense.