How to Merge/combine 2 Roaster(old children list+New list) table in to one
Posted: May 15th, 2022, 10:29 pm
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 if in Roaster SECA1 , the number of children listed are 3 and occupying's Curocc() position 3, 4 ,5 and in Roaster If I capture 1 child and maybe the child occupied curocc() position.
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 w also joined starting from row3,4 and 5 respectively..
Please somebody help.
Sham.
I attached the file
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 if in Roaster SECA1 , the number of children listed are 3 and occupying's Curocc() position 3, 4 ,5 and in Roaster If I capture 1 child and maybe the child occupied curocc() position.
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 w also joined starting from row3,4 and 5 respectively..
Please somebody help.
Sham.
I attached the file