How to merge list of roaster1 and Roster2 to form a new Roster as Roster3
Posted: May 16th, 2022, 6:16 pm
Hi Sherrell, Gregory, htuser and the rest of the family on this plat form,
My issue is not resolve yet. I need your help urgently pls on the above subject.
Below is the logic I used which is not working so well. am sure there is mixed up somewhere.
Hi Family,
Please I need your support to meet to be able to meet the is deadline.
// Prefill in names in names roster from enumerator data file
numeric numPreloadIndividuals = count(MEMBER_DICT.MEMBER_REC);
do numeric i = 1 while i <= numPreloadIndividuals
if SA1_5(i) = "Child" then
ID_OF_CHILD(i) = PID(i);
CHILD_S_NAME(i) = S1_2(i);
endif;
enddo;
do numeric i = 1 while i <= count(LEAP1000R_DICT.SEC2B);
ID_OF_CHILD(i) = NEW_MEMBER_ID(i);
CHILD_S_NAME(i) = Concat(SEC2BQ2(i),"",SEC2BQ3(i));
enddo;
After testing the logic , I realized for example if in Roaster SECA1 , the number of children listed are 3 and occupying's Curocc() position 3, 4 ,5 and in RoasterSEC2B If I capture 1 new child and maybe the child occupied curocc() position1.
So the results in Roaster SEC3. is messing up...The list either override the other and or it create some gabs especially when the new child added it is just 1. You will see in Roaster SEC3. the new child will occupy Row1 and row2 will be vacant and and the old children also joined occupying the curocc(3,4 and 5) respectively..
Please somebody help.
Sham.
I attached the file
My issue is not resolve yet. I need your help urgently pls on the above subject.
Below is the logic I used which is not working so well. am sure there is mixed up somewhere.
Hi Family,
Please I need your support to meet to be able to meet the is deadline.
// Prefill in names in names roster from enumerator data file
numeric numPreloadIndividuals = count(MEMBER_DICT.MEMBER_REC);
do numeric i = 1 while i <= numPreloadIndividuals
if SA1_5(i) = "Child" then
ID_OF_CHILD(i) = PID(i);
CHILD_S_NAME(i) = S1_2(i);
endif;
enddo;
do numeric i = 1 while i <= count(LEAP1000R_DICT.SEC2B);
ID_OF_CHILD(i) = NEW_MEMBER_ID(i);
CHILD_S_NAME(i) = Concat(SEC2BQ2(i),"",SEC2BQ3(i));
enddo;
After testing the logic , I realized for example if in Roaster SECA1 , the number of children listed are 3 and occupying's Curocc() position 3, 4 ,5 and in RoasterSEC2B If I capture 1 new child and maybe the child occupied curocc() position1.
So the results in Roaster SEC3. is messing up...The list either override the other and or it create some gabs especially when the new child added it is just 1. You will see in Roaster SEC3. the new child will occupy Row1 and row2 will be vacant and and the old children also joined occupying the curocc(3,4 and 5) respectively..
Please somebody help.
Sham.
I attached the file