Consolidating Duplicate Text Entry Responses to Display Only Once | XM Community
Solved

Consolidating Duplicate Text Entry Responses to Display Only Once

  • 14 November 2019
  • 1 reply
  • 26 views

I'm fairly new to Qualtrics and am hoping someone here can help me with a current survey issue I'm unable to get past. I have several Text Entry questions with more than one text field asking survey respondents to enter company names they may have an interest in. I have already given a distinct list of companies in other sections, and these Text Entry questions are meant to gather unanticipated responses. As a result, they must remain Text Entry.

!

Each asks essentially the same question for different topics of interest and time frames (past, present, future). Due to this, survey respondents could enter the same company name into several of the Text Entry fields across multiple questions.

Using Display Logic, the answers to these many questions are then piped into a single Pick, Group & Rank question for survey respondents to do just that.

For this to work properly for the outputs I require, I need any duplicate responses piped from all of the Text Entry questions to ONLY be presented as a SINGLE option in the Pick, Group & Rank question. As an example:

If a survey respondent were to enter "IBM" 4 times into different Text Entry questions, I currently receive 4 separate "IBM" options listed in the Pick, Group & Rank question:

!

However, the desired output for the options in the Pick, Group & Rank question from the 4 entered "IBM" responses is just a single "IBM" option:

!

I've attempted several Display Logic solutions (primarily using "AND" and "Is Not Equal To" the piped text from the prior Text Entry questions) for the individual options in the Pick, Group & Rank question, but have only succeeded in being stuck with the original state showing multiple of the same Text Entry response or showing no duplicate responses.

Do any of you fine people have a solution? Thank you!
icon

Best answer by LaurenK 11 December 2019, 22:49

View original

1 reply

Userlevel 7
Badge +13
Hi @sthom6! It looks like you were able to work with one of our Qualtrics Support specialists to come up with a solution to this inquiry. It seems as though you were able to accomplish your goal through the use of Piped Text and Display Logic. We would love it if you posted the response you received from the Support team so that if any other community member is interested in a similar setup, they will know the solution!

Leave a Reply