...
- Gaps in mappings
- questions which have not been mapped to variables
- questions which have not been mapped to topics
- variables which have not been mapped to topics
- Any obviously incorrect topic mappings
- Variables which have not been mapped to questions are in the DVs tab
If there are issues to resolve, the spreadsheet it then sent back to the study to complete. The finalised Excel file is then reformatted into the qv.txt, tv.txt, tq.txt and dv.txt as described below. They are then loaded into Archivist as descried below, and checked for any conflicts or gaps. If there are any issues, the all_mappings.txt (e.g. ncds_65_eq_all_mappings.txt) is downloaded and used to highlight these to the study. This includes all questions and all variables, even if they are not mapped but doesn't include any derived variable mappings. Topics will also need to be added. Note that there are sometimes carriage returns in the file which will need to be removed, so the file can be opened in Excel.
...