We designed a form to collect data at the household level with a specific group-repeat section to gather information at the individual level from each household. I am able to link the parent-child relationship between household and individual through the "index" column in the form.
However, I have lately found with a strange error: we perform data cleaning every day at the end of data collection, meaning that each day we download the whole dataset, delete the old entries and clean only the new ones.
When trying to collate each individual cleaned dataset, I find duplicates under the "index" column (i.e two "1", two "2"). The tool went through some minor updated during data collection, is it possible that the index was restarted after each update?