possible to join (as in SQL) two datasets in Vocalize?
Best answer by LaurenK
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.

[Instructor ID] comes from the uploaded file and EMP_ID is an embedded data field from the survey, and I mapped them both to the variable named "Instructor ID" for the sake of simplicity.
As I said, though, this is producing a 'union' rather than a 'join'. Looking at the records for 001084901 as an example, for which I populated the survey with test data, the uploaded dataset has 12 records. After mapping the two datasets based on that field, I end up with 13 records: 12 for the uploaded, and one for the survey, evidenced below by how the data is written as N/A for survey fields on uploaded records, and vice versa.
!
My thought is that if it were a true 'join', I'd see the original 12 records from the uploaded dataset only, with copies of the survey response data appended to the left of each of those records, so that I'm seeing all the original records for each ID that is entered into the survey. But instead, it is producing a new record in which none of the original dataset fields are populated.
Is producing that actual 'join' possible? I would love to find out I'm doing something wrong!
Thank you for your help! :)