Forum Discussion
Label based on the date condition and categorize.
I have a dataset with (grandparent-parent-child relation) this together is one set. I have mulitple such sets in datasource. requirement here is Definetly DOB of GrandParent will be the least, but if...
GPc1 - {Pc1,c1} -{Pc2,c2} - {Pc3,c3}
logic: Date of birth of GPc1 > Pc1/Pc2/Pc3 > c1/c2/c3 - Valid scenario
but suppose Dob of c2>Pc2 then it should be labelled as "Mismatch"
and it only [GPc1 - {Pc1,c1} -{Pc2,c2} - {Pc3,c3}] this is pair and should not be compared with other set like c2 with GPc10 because GPc10 is grandparent of some other family.