I'm having troubles pulling rows from a dataset. They need to match a row in another dataset. Here's an example DATA1 TYPE1 TYPE2 VALUE1 VALUE2 HAIR EYES BROWN BLUE SEX EYES MALE BROWN HAIR SEX BLONDE FEMALE SEX EYES MALE BLUE DATA2 NAME HAIR SEX EYES ROGER BROWN MALE BLUE GLEN BLONDE MALE HAZEL JULIE BLONDE FEMALE BROWN I want it to pull records in data2 based on matching the criteria in data1. The value in data1 will exactly match the column name in data2. So the result would be: ROGER JULIE Because their attributes match those laid out in data1. I've spent a lot of time trying different approaches. Hopefully you guys can help. Thanks!
... View more