Checklist for Pipeline table upload
1. Check for any white spaces in all labels and remove them (use trim() function in Excel.)
2. Cross check the Code List/response domain and Question Item tables to verify the response domain is correctly attached (checking that if there is one attached that it is in the
corresponding table and the labels match) with each question item (use VLOOKUP function in
Excel).
3. Check Parent_Name in tables Sequence, Statement, Question item, Question grid, Condition,
Loop match with the same label as the table referred to in the Parent_Type table (use
VLOOKUP function in Excel).
4. Check the code lists attached in the Question Item table have values (no blanks) for the
min_responses and max_responses. Response domains should be blank (use filter).
5. Check for duplicate code lists attached in the Question Item table which have different
min_responses and max_responses (a code list must have unique min and max cardinality)
(use filter).
6. Check the positions across the Sequence, Statement, Question item, Question grid, Condition
and Loop tables to make sure they are in order within each Parent_Name, ensuring that the
are no items across the tables which have the same Parent_Name and Position. (use filter)