Kindly help me with the logic for this one.
If the relation is husband, then all the other observations following it until another husband occurs should be read into a single record, and i need to get corrresponding spouse and child name in the same husbands record but with spouse and child name.
Data to be processed:
NAME AGE GENDER RELATION
A 40 M HUSBAND
B 30 F sPOUSE
C 10 M CHILD
D 40 M HUSBAND
E 30 F SPOUSE
F 10 M CHILD
REPORT:
Name age gender relation spouse child
a 40 m husband b c
d 40 m husband e f
... View more