Using VZ Autofill

VZ Autofill

We created VZ Autofill to speed up the Data Prep process. We created logic based on how each survey software exports its survey data by question type and came up with logic to translate that into how VizualSurvey standardizes the data. When using VZ Autofill you still need to verify that the New Question # and Question Type are accurate. VZ Autofill gets it right most of the time but due to the customizability of surveys and the multiple ways, a survey question can be programmed it could get it wrong. You should be able to recognize this easily in the Clean Data step and change it on that screen. If you do not have any of the survey software's below you can skip this article and go to the Creating a Workflows and Uploading Data article.

Qualtrics

For Qualtrics you need to export the data with the question coding and the question text. Normally the data is exported with 3 rows as shown below. We will need to get rid of that 3rd row and merge the first 2 rows so that we have the question code/number and the question text all in the same cell. Below are the instructions on how to accomplish that.

Exporting and Preparing the Raw Data

1. Delete the 3rd Row

If a 3rd row is exported in your data with coding then delete that row. If there is no 3rd row then create a 3rd row that is empty.

2. Concatenate the first two rows

Click on the first empty cell and concatenate the first two rows using the formula above. 

  1.  Push = on your keyboard
  2. Select cell A1
  3. Push & on your keyboard
  4. Select cell A2
  5. Press enter
3. Fill across

Now you will fill across that row by hovering over the bottom right corner of that cell till you see a "t" icon. Click and hold and go to the end of your data.This will copy that formula across all the columns.

4. Copy and Paste Values

Copy that entire row and then go to paste and paste values.

5. Delete the first 2 rows

Now you can get rid of those top 2 rows and you will be left with one row which will have the question coding/number and question text combined. Use this file to upload your data into VizualSurvey

Uploading Data and Selecting Qualtrics VZ Autofill 

Using this new file you have created, upload it to the software and select the Qualtrics VZ Autofill option when you first load the data or you can select the option once you are in the Prep step under Actions if you have selected the Don't Apply button when first uploading.

Option 1: VZ Autofill Option Uploading

Option 2: VZ Autofill Data Prep Screen

QuestionPro

The VZ Autofill works different for QuestionPro because the data needs to come from the API to work properly. The only use case you will need this for is if you have used the QuestionPro API to import the data and for some reason the Prep Data logic was not applied. You can then use the VZ Autofill= QuestionPro to apply the logic. The other use case is if you messed up the New Question # and Question Type and you wanted to reset the logic and reapply it.