Updating Projects with New or Revised Data

From Q
Jump to: navigation, search
Related Online Training modules
Updating Data
Generally it is best to access online training from within Q by selecting Help > Online Training


Any Q project can be automatically updated using a revised data file (e.g., a file that contains additional interviews or corrections to the original data). This is done by selecting File > Data Sets > Update. Where the structure of the data file remains unchanged, Q will automatically update any computed variables and tables in the project.

Automate quality assurance

Q will alert you in situations where a variable that has been constructed in Q has been broken due to removal or change of a variable used to construct the variable. Such changes will be represented with the broken variables showing a Status of INVALID – the drop-downs can be clicked on to obtain more information about the problems.


If you are happy to proceed with importing the updated data, press Accept and review the contents of the Status column on the Variables and Questions tab.

In the Variables and Questions tab, you can also see which variables are NEW, INVALID, CHANGED or OK under Status – an example is shown in Figure 33. You can click on the drop-downs under Status to obtain more information.


If there are discrepancies between the data file used to create the project and the updated data file, it may result in work being lost. For example, if a code frame has been revised, it may “break” any filters created using the question with the revised code frame and ruin any merging and renaming of categories in tables using the question with the revised code frame. This is by design. That is, while painful, it is better to lose work than to continue working without being aware that the code frame has been revised. Q gives warnings when this is about to occur.

Buttons, Options and Fields

Value Attrs Copy.png Copy Copies the table of data differences to the clipboard, to allow them to be pasted to Excel. This button was introduced in Q 4.10

See also