To import stacked data into a project following the steps below:
- Import the normal non-stacked part of the data as per normal
- Import the stacked data file, in the Import screen you have to confirm that the file to import is a Stacked file so a different validation process is applied as the file does not contain the standard Weight, Response date fields and there are also duplicates in the Respondent ID fields.
- In the data activation page activate both files. During the activation process all respondents in the stacked file are validated as these respondent IDs must be present in one of the activated normal files, if not the activation will not be successful and there will be an error message identifying the missing Respondent IDs.
Note: the stacked file will be connected to your main file based on RespondentID: this means you can not create a unique RespondentID in Dapresy, because the system will not be able to connect the files. So it's mandatory to have a unique RespondentID in your main file and this RespondentID should also exist in your stacked file (but will not be unique in the stacked file).
The image below shows the Import screen, the tick box “Stacked data to be connected to existing data sets” has to be ticked when the stacked file is imported. The same option is also available in the Import scheduler page.
The image below shows the Data activation page, in the Batch type column all the imported Stacked files are displayed as “Stacked data”. The Number of Respondents column shows the sum of the unique number of Respondent IDs.
The order of the activation is not important. However, be aware that you cannot load stacked data to inactivated unstacked data. It needs respondent data to match/merge.