...
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 and any rows which don't contain mappings are removed. 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.
Question to Variable mappings
...