Merge Questionnaires using id... (AskiaTools)
Use this function to merge two questionnaires' respective data-entry masks and data into a single *.QES file, as well as to merge interview data contained by both files according to a common ID variable.
Note: this operation can also be carried out using the
command line.
This merge operation will import the secondary *.QES file's data and its data-entry mask into the primary *.QES file, listing it at the end of its pre-merge data-entry mask. Furthermore, interviews possessing an identical ID will be merged into a single and unified interview sheet.
For example:
- primary *.QES contains 10 interviews. The ID of interview 7 is "r;ABC".
- secondary *.QES contains 5 interviews. The ID of interview 3 is "r;ABC".
In this example, AskiaTools will merge the data of both interview sheets, and so the resulting primary *.QES file's interview sheet 7 will contain its own pre-merge data plus the new data which came from the source *.QES file’s interview sheet 3.
To merge questionnaires using IDs:
-
Open the primary *.QES file, which will contain all merged data.
-
In the merge menu, select questionnaires using id.
-
In askia file, click 
to select a secondary *.QES file, or 
to select an AskiaField task. If you select the latter, the AskiaField tasks dialog appears.
-
In interviews, select the type of data source: QES file, SQL server (legacy format), SQL server (new format) or inverted database.
-
In identifiers, select the question that contains the respondent IDs in your target (primary) QES, and then the question containing respondent IDs in the data source.
-
Finally, click OK.
AskiaField tasks dialog
If you choose to merge data from an askiafield task, you can specify the task details here. The available options are:
| Option |
Description |
|
Connection to AskiaField database
|
Enter the connection string to the call centre database.
|
|
Surveys
|
Select the survey from which you want to import data (once you have completed the connection to AskiaField database option above).
|
|
Askia file
|
Specify the QES file associated with this survey. To browse for the file, click ....
|
|
Connection to surveys database
|
Enter a reference to the database's DSN, in the following format:
;DSN=BDDASKIA
|
|
Survey ID
|
Enter a unique identification number for this project.
|
|
Interviews storage
|
Select the location where the interview data is stored. This can be the QES or the SQL server (in either legacy or new formats).
|