In the 'DATA' – Import' – 'Merge data' tab, you can merge data from different sources based on a common key.

Of course, the key must be different between the units - different units must not have the same key. For data merging, it is essential that the 1KA file has the same key (identifier) as the additional file, e.g. sequence number, code, email, phone, etc.

Example: the Q1 variable in the 1KA database contains names of respondents and you wish to add e-mail address (E-MAIL) and age (AGE) for each respondent. In the 'EDIT' - 'Questionnaire' tab, you can create two new variables (for the e-mail address and age) and then go the 'DATA' – 'Import' – 'Merge data' tab, where you can choose all three fields: Q1, E-MAIL, AGE. Each unit has to be in its own row and variables have to be separated with a comma.

It is important to maintain the order of the variables, which can be determined by moving the fields around.

It is very important to mark the Q1 variable as the key in this example. The system will then add the email address and age from the additional file (e.g. Ana, ana.novak@1ka.si, 33) to the units in addition to the names (Q1) already in the 1KA database.

You can also export the e-mail addresses and names from an external file (Excel).


The functionality is available for users of the 3KA package for individuals, and for users of the business packages for groups.


Related content

1KA is free to use for basic users