Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
I try to create simple solution. I split records by gender, then apply sorting over each data set. After sorting I've got the first record from each year and at the end I join both stream using Year like key field.