You are right. You can achieve this using the dashboard. You can combine text fields from different surveys and analyze the comments.
Thanks for the input - I am wanting to combine all the verbatim questions into one data field for searching purpose - this is what I am unclear how to do?
Hi @ccarroll
I think what you have in mind could be achieved by building a kind of pivot/stacked dataset in which each row would contain a verbatim and information about its origin.
In each survey, you could build daily workflows to extract the survey responses and use a basic transform task to create unique IDs (could be concat responseId + question, for example) and to uniformize the fields’ names. You could then load the results into an IDP.
The initial setup would be a bit heavy since you would need one such workflow for each of your 5 open ended questions for each of your 20 surveys, bit in the end you would end up with an IDP containing rows similar to this:
uniqueId | sourceSurvey | sourceQuestion | verbatim |
R_037SfMKD3Mg8yVM_Q1 | SV_A | Q1 | Verbatim 1 |
R_037SfMKD3Mg8yVM_Q2 | SV_A | Q2 | Verbatim 2 |
R_3dWhMnwIQ3jfELI_Q1 | SV_B | Q1 | Verbatim 3 |
R_3dWhMnwIQ3jfELI_Q2 | SV_B | Q2 | Verbatim 4 |
Thanks for the input - I am wanting to combine all the verbatim questions into one data field for searching purpose - this is what I am unclear how to do?
But with dashboard mapping it will combine open end from all surveys in on field that can be used for search purpose.