CONCATENATE - combining answers through survey flow

helena_kultanenhelena_kultanen FinlandCommunity Member Qubie ✭

CONCATENATE - combining answers through survey flow


Has anyone tried to combine answers from different (open ended) fields into one data field, for reporting purposes?

In excel I would use "CONCATENATE" and I was wondering if this would work from survey flow as well.

The situation is, that for various reasons, we would have e.g. 3 fields of open ended (form) questions, that would need to be kept separate in the form. However, I would like to create a word cloud out of all of the responses. How can I concatenate the answers into one variable through survey flow? Or what would better serve this purpose?

The new, combined variable should be usable in Vocalize.


Best Answer

  • SaurabhPujare_UgamSaurabhPujare_Ugam India Sage ✭✭✭
    edited April 2019 Accepted Answer

    Hi Helena,
    1. Create an embedded variable say "CombineText"
    2. In values click on blue down arrow and select insert piped text and from the question from the list select the form entry option that you need.

    1. Do this for all other option by appending the later options to first.
    2. Your embedded variable will look something like this:


  • GeorgeIssaGeorgeIssa Pennsylvania / Global OrganizationCommunity Member Guru ✭✭

    Nice! =CONCATENATE is such a useful formula for spreadsheets.

  • helena_kultanenhelena_kultanen FinlandCommunity Member Qubie ✭

    Thank you! This will be very helpful for us!

  • jmwoodjmwood Community Member Qubie ✭

    As a follow up to the thread above, I would like to concatenate two fields via survey flow for reporting purposes and add a comma and space between them. Right now the output appears as LastNameFirstName. I would like the output to read: LastName, FirstName.

Sign In to Comment