This is for cleaning data from the system it needs to be based on a survey file which has this script icon: 
Trying these steps on a data file, will not work.
If you would like to remove any completed surveys due to quality checks, these are the steps for that.
Getting the Data:
On your project, click on the three dots on the right side and select “Analyze”
- Select the “Data” icon
- Drag any questions you want to check into the area that says “Drop rows here” – these will be the questions you want to check for quality
- Select “Options” and tick the option below, this will include the system ID that we will need to use for removals
Click export to get the questions in excel format.
You can now highlight any respondents you need to remove. [note this export is only for data in the COMPLETE status].
Data Editing
- From the file you created in the first stage, you should have identified the respondents to remove. You only need the Case ID, no other data is needed.
- Create a blank excel and add two column headers
- This col A is where you would past the Case ID of those you want to remove
- This is where you would set the status you want them to be, the example below shows all the possible status.
3. Here is an example of how the file could look for quality removals, where the first Id would be flagged with the SCREENED status and the second id would be a QUALITY FAIL.
4.Now we need to upload the file so the removals can happen. Select “Edit Data”
5. Select your file and upload.
The data and quotas will be updated once the process is completed.
Additional tips and tricks:
There are two types of data cleaning, Walr uses both of them to check data before it is loaded for analysis. If you are using the Walr platform to “DIY”, please refer to the recommended processes below for cleaning your data.
1. Data Logic check à Checking the logic of the survey questionnaire versus what was programmed. This is done by, for example, checking the base of each question in the data versus what is expected from the questionnaire.
2. Data Quality check à This includes bad open-end checks, straight liners check and speeders check.
2a. Open-End Check à Identifying any bad open-end responses, which are any respondents that are answering the question in any way other then what was required.
2b. Straight liners à Checking if respondents have answered the same option in, for example, grids or carousels. You can identify an acceptable level and exclude anyone outside those parameters.
2c. Speeders à Minimum acceptable duration spent on certain questions, sections, or the entire survey.