4 Replies Latest reply: Dec 8, 2014 4:33 PM by Peter Rieper RSS

    Combine multiple fields into one common field

    Brian Garside

      I have several Race fields that should be combined into one common field since they have a common attributes.

       

      The problem is how do I combine the Six fields when they have a Y/N value for each one and map it to the label of the fields?

       

      Current Schema:

      FieldValue
      Race: WhiteY/N
      Race: BlackY/N
      Race: HispanicY/N
      Race : AsianY/N
      Race : IndianY/N
      Race: OtherY/N
      Convert to This:
      Values
      RaceWhite
      Black
      Hispanic
      Asian
      Indian
      Other