Gather survey responses from multiple rows

Gather survey responses from multiple rows


When each respondent is represented by multiple rows (a row per survey question), you can use the Auto Code Dataset Wizard to gather the responses at a node.

In this example dataset (below), there are two survey questions. Each respondent therefore has two rows in the dataset, one row for the response to each question.

Respondent Question Answer
Anna 1 I think there should be more car-free zones
Anna 2 Electric buses and taxis would help reduce pollution in the inner city
Jack
 
1 Pedestrians need to feel safe. There should be better lighting and more police
Jack 2 We should create more green spaces
Maria 1 Safety barriers at busy intersections
Maria 2 I don't think they should tax car parks
Peter 1 Better education in schools about road safety
Peter 2 More street trees

If you want to gather all responses to Question 1 and Question 2 at separate nodes, you can use the Auto Code Dataset Wizard (select Code at nodes for each row) to code the content in the Answer column at nodes representing the values in the Question column. The wizard will create two nodes:

All responses to Question 1 will be coded at the first node, and all responses to Question 2 will be coded at the second.

Alternatively, you could gather the responses of each survey respondent at nodes Anna, Jack, Maria and Peter—use the Auto Code Dataset Wizard (select Code at nodes for each column) to code the content in the Answer column at nodes matching representing values in the Respondent column. The wizard will create four nodes:

Each person's answers (to both questions) will be coded at the node that represents them.