Creating multi-value attributes by splitting or merging attribute values

When creating a new data set, you can create multi-value attributes, either by splitting an attribute value based on a delimiter, or by merging values from multiple attributes.

For example, for an attribute with the value "blue;white;red", you can indicate that these are actually 3 individual values delimited by a semicolon. Studio also trims any white space between the values.

Or for data with the attributes Color1, Color2, and Color3, you can merge the Color2 and Color3 values with the Color1 value to create a single multi-value attribute. When you merge attribute values, the default separator for the current locale is used.

To create multi-value attributes:

  1. On the Add Data Set page, click Advanced Options.
    Advanced Options for data set attributes
  2. To split the value of an attribute:
    1. Check the Split checkbox for the attribute.
    2. On the split value dialog, under Values are delimited by, specify the delimiter used to separate the values.

      Split Value dialog

      Select the delimiter from the drop-down list.

      If the delimiter used is not in the drop-down list, click the other radio button, then type the delimiter in the field.

    3. To save the split configuration, click Save.
    4. If you need to change the split configuration, click the edit icon in the Split column.
    5. To not split the attribute value, uncheck the Split checkbox.
  3. To merge other attribute values to an attribute:
    1. Check the Merge checkbox for the attribute.
    2. On the merge dialog, from the Attribute drop-down list, select the first attribute to merge with the original attribute.
      Dialog to configure merged attributes for a data set

      You can only merge attributes that have the same data type.

    3. To add an attribute, click the Add Attribute button, then select the attribute from the drop-down list.
    4. To remove an attribute, click its delete icon. You cannot remove the original attribute.
    5. To save the merge configuration, click Save.

      On the Add Data Set page, you can no longer edit the merged attributes. They automatically inherit all of the configuration options you specify for the original attribute.

      The Merge checkbox for the merged attributes is also checked.

    6. If you need to change the merge configuration, click the edit icon in the Merge column.
    7. To remove the merge, uncheck the Merge checkbox.