Database link wizard: Database import/export options
This page appears when you are importing or exporting data between a survey and a database using the database link wizard.
| Join cases where the link variables match | Update the variable data for cases where the specified link variable is matched in the source survey and the import data. Do not import cases where the link variable does not match. |
| Join matching cases and append unmatched cases | Update the variable data for cases where the specified link variable is matched in the source survey and the import data. Add new cases for each new value of the link variable. |
| Append unmatched cases only | Do not update the variable data for cases where the specified link variable is matched in the source survey and the import data. Add new cases for each new value of the link variable. |
| Append all cases | Add all cases from the import data without checking if they already exist. (Cases may be duplicated but never overwritten.) |
| Link Variables | Specify which variables will be used to match cases across the surveys. |
| Database field | Select the field to match to a Snap variable or case number. |
| Use Snap variable | Select the variable to match on from the drop-down list. |
| Use Snap case number | Use the Snap case number (system data) to match cases. |