How to filter out records and dependency on other column?
I have attached a sample data to elaborate my problem.
Assumption: the source data cannot be modified.
I want to show the FAMILY which have at least 1 "F" in SEX column.
I have attached a sample data to elaborate my problem.
Assumption: the source data cannot be modified.
I want to show the FAMILY which have at least 1 "F" in SEX column.