Hello,
I would like to identify groups that are totally independants.
In this example, there would be 2 groups:
-Albert, Alex and Claude that have one-to-one features in common: the eyes ( green) and/or hair (black) and/or nose(long) IN GROUP 1
-Audrey and Claire that have blonde hair IN GROUP 2
FIRST_NAME_09-->CODE_09------------->GROUP
ALBERT--> EYES_GREEN------------>1
ALBERT--> HAIR_BLACK------------>1
ALEX----> NOSE_LONG------------>1
ALEX----> EYES_GREEN------------>1
ALEX----> HAIR_BLACK------------>1
AUDREY-> HAIR_BLONDE------------>2
CLAIRE--> HAIR_BLONDE------------>2
CLAUDE-> NOSE_LONG------------>1
CLAUDE-> HAIR_BLACK------------>1
Important:
I am looking for a general solution to this problem, that can manage thousands of features.
To make it easier, there would never interferences between 2 groups : for example one person from group 2 will never have green eyes or long nose.
Is it possible to create through SQL/function a query that automatically compares and create groups?
Find here database
Thanks in advance for help!