-
Scenario based
If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...