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
+38Huiling you may be better off merging Files A and B outside of Qualtrics and then Importing the merged file as responses in File A where it seems like you want all of your data.
If you have access to Microsoft Excel, you can use the vlookup function to pull the values of confusion and suggestion in File B into File A.
I then recommend making a copy of the survey used to collect File A. And using the Qualtrics Importer to put your merged data into Qualtrics.
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.