Combining Fields

Suite
Employee Experience Strategy & Research
Product
Qualtrics
What's on this page

About Combining Fields

You can combine almost any 2 or more fields that you want. This can happen at any time before, during, or after data collection.

There are 2 different ways to decide what value the new, combined field has:

Concat: This is short for “concatenate.” When you select this option, you are choosing to link combined answers together.
Example: You ask for the respondent’s favorite appetizer, main dish, and dessert. You choose to concatenate the answers with slashes ( / ), so the answer appears as Soup/Roast Beef/Cake.
Coalesce: When you select this option, you can choose what order to check each field for values if one or more are empty.
Example: You ask for the respondent’s favorite dish at the beginning of the survey, and then accidentally ask them again at the end. You decide that whatever answer they gave first is fine, but if they left that field blank, you want their last answer.

Need to make changes to fields you previously combined? See our Editing Custom Fields page.

Warning: Do not delete fields you are using in combined fields, or you will lose your combined field’s data.

Qtip: If you are concatenating multiple choice answers, whether they have custom recode values or not, the concatenated field will use the recode values instead of the answer choice text. For example, let’s say you ask respondents to pick a t-shirt size and color, and want to concat these responses together.
two questions in the survey editor
two questions in the survey editor

To see each answer’s recode, click the question, then choose Recode values.
the recode values window open in the survey editor
the recode values window open in the survey editor

After concatenating these 2 fields, the resulting field has the respondent’s combined answers, except they are represented by the recode values instead of the choice text.
two variables have been combined in data & analysis. the combined variable uses the recode values of the original fields
two variables have been combined in data & analysis. the combined variable uses the recode values of the original fields

Concatenated Fields

Concatenated fields link 2 or more fields’ values together into a list. In other words, instead of one answer overriding another, answers will appear “First Answer|Second Answer.” You do not have to use | as the delimiter.

Once created, concatenated fields can be analyzed in Text iQ.

Qtip: You can concatenate 2 – 20 fields at a time.
Qtip: If you want to combine text fields instead of recode values, we recommend concatenating open text fields like text entry answers or embedded data.
Go to Data & Analysis.
the create new field option in the tools dropdown in data and analysis
the create new field option in the tools dropdown in data and analysis
Make sure you are in the Data section.
Select Field Editor.
Click Create Field.
create field button in field editor
create field button in field editor
Select Combine.
a combine variable set to concat. comma is the delimiter and the selected fields are latitude and longitude
a combine variable set to concat. comma is the delimiter and the selected fields are latitude and longitude
Make sure Concat is selected.
Name your field.
Choose your delimiter. This is the symbol or text that separates values.

Qtip: A few extra facts about delimiters:

  • This doesn’t have to be a symbol, and can contain letters or numbers.
  • This field cannot be empty.
  • The spaces you see in the example are not representative of the final appearance. Answer will appear as a,b rather than a , b.
  • You cannot add extra spaces on either side of the delimiter(s), but you can add spaces in between delimiters. E.g., “and / or” is valid, but “ and / or ” is not since it begins and ends with an extra space.
Select the first field that will appear in the list.
Select the second field that will appear in the list.
Click Add Field to add more fields.
Qtip: You can also click the plus sign ( + ) next to a field to add a new field there.
When you’re ready to create the combined field, click Create Field.
Click Review and Publish to save your changes.
review and publish button
review and publish button
Click Publish your Changes.
publish your changes button
publish your changes button
Qtip: Click Data Table to return to your response data.
data table button at top of the field editor
data table button at top of the field editor
Attention: Your data may be temporarily unavailable while this field is being created.
Qtip: Concatenated fields are always set to the “text value” type, even if you are using recode values. This cannot be changed, even when mapping the field to a CX Dashboard.

Coalesced Fields

Coalescing fields means allowing one answer to override another.

Only 1 value will be chosen at a time. If field (a) isn’t available, the answer will be (b). The field will continue working down the list until there’s an available answer. You can choose between 2-5 fields.

Qtip: The resulting coalesced field’s type is dependent on the fields used to build it. This field type cannot be changed, even when mapping the field to a CX Dashboard.
Go to Data & Analysis.
the create new field option in the tools dropdown in data and analysis
the create new field option in the tools dropdown in data and analysis
Make sure you are in the Data section.
Select Field Editor.
Click Create Field.
Select Combine.
a combine variable set to coalesce. two fields are selected; recipient first name and recipient last name
a combine variable set to coalesce. two fields are selected; recipient first name and recipient last name
Select Coalesce.
Name your field.
Choose the field that your new combined field should check for a value first.
Choose the field your new combined field should check for a value if (a) is empty.
Click Add Field to add more fields.
When you’re finished, click Create Field.
Click Review and Publish to save your changes.
review and publish button
review and publish button
Click Publish your Changes.
publish your changes button
publish your changes button
Qtip: Click Data Table to return to your response data.
data table button at top of the field editor
data table button at top of the field editor
Attention: Your data may be temporarily unavailable while this field is being created.

Fields that Cannot be Combined

You cannot use the following types of fields to create a concatenated or coalesced field:

Projects Where You Can Create Combined Fields

Depending on your license, you may have access to several different types of projects that have a Data & Analysis tab. The options described on this page are available in:

Qtip: When custom fields are added to a CX Dashboard, they become derived data. Although supported, they behave a little differently than other survey fields do. See Derived Data for more details.

While the functionality is technically available, we do not recommend using these custom fields with other types of Employee Experience projects. See Creating New Fields (EX) for more details.

Qtip: While other areas of the platform (like dashboards, Stats iQ, and directories), may also allow you to create new fields, this support page is solely focused on how to create concatenated or coalesced fields in Data & Analysis. For steps on creating other kinds of fields across the XM platform, try narrowing your support site search.

FAQs

How do I edit my custom fields?

My custom fields don't have data and say "Invalid." What happened?

Was this helpful?

The feedback you submit here is used only to help improve this page.

That's great! Thank you for your feedback!

Thank you for your feedback!