Condense text verbatims

Squish multiple responses into one distribution

Updated at March 6th, 2020

Transform to condense is most commonly applied to text open-ends. This functions allows you to condense multiple text columns into a single distribution. 

For example, the survey below elicits multiple reasons.  For analysis we'd like to combine these three open-ends into one single list.


To condense the values, place the elements in a group (e.g. qV) as above. Press the edit icon for the group and select "Transform..." from the context menu to bring up the transform dialog:


The text responses are now condensed into a single distribution.   


This is a multi-value element, so percentages may sum to more than 100%.  Below selecting people who chose "Experience" shows they also entered other reasons:


"unique" attribute

For a squished group, in the JSON editor you can add an attribute "unique". Below, Q22 has "unique" : false and the clone Q22_copy has "unique" : true. Filtering the view for one respondent (e.g. 50625), you can see that when "unique" is set to false each value is counted separately. N size will be the number of response values. When "unique" is set to true, Protobi will recognize the multiple responses are from one respondent and N size will only count unique respondents. 

Remove the transform

To undo a transform, go to the group's context menu and select "Expand/collapse." Then, bring up the transform dialog and select "None." The group should return to its original state.


Video tutorial

Condense multiple text columns


See Condense text verbatims article for more information. 


See related

Transform dialog

Was this article helpful?