Merging two files based on a common question

Huiling · 2020-08-11T16:28:55+00:00

Hello everyone!I need some help for merging two files based on a common question. I appreciate it very much if anyone can help me.Let's say I have files, file A and B. File A is the main file with these questions: seat number, gender, age, ethnicity, rating 1, rating 2, rating 3, confusion, suggestions. File B has these questions: seat number, confusion, suggestions. When I collect the data for the file A, the data for confusion and suggestions are not ready. Later on, I collect the data for the file B. Now I need to merge the data of confusion and suggestions to file B based on the seat numbers. I tried different ways in Qualtrics, like "Legacy Importer", but it did not work, instead of merging them, Qualtrics added those records from file B to file A. Somebody helps!Thank you very much! 😊

Merging two files based on a common question | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded