How do I merge profile variables?

When there are two profile variables created that collect the same information, merge results from one profile variable into the other. 

Example

There are two profile variables created called "favorite_color" and "favouritecolour" with the same type of data. We want to merge the data from "favorite_color" into "favouritecolour."

Detailed Steps

Create a member group with the profile variable that will get merged

1. Open the Community app and click Community > Member Groups at the top of the page.
2. Click New Member Group and enter in a name for the member group.
3. In the dialog, filter members based on members who have a value for the profile variable "favorite_color."
4. Click Save.

Export the member group along with the profile variable

1. On the toolbar on the top left of the page, click Export.
2. Click New.
3. Within the Export Profile Data dialog, select the member group previously created and include the profile variable "favorite_color."
4. Click Export.

Rename the profile variable

1. Open the exported CSV and delete all the columns except for "memberID" and "favorite_color."
2. Rename the column header from "favorite_color" to the other profile variable's name, "favouritecolour."
3. Save the CSV.

Import the profile variable to merge

1. Open the Community app and click Community > Profile Variables at the top of the page.
2. On the toolbar on the top left of the page, click Import.
3. Click Choose File and upload the CSV created.
4. Click Upload.

Result: Data from both profile variables are combined under the profile variable "favouritecolour."

More information

• Create a member group
• Import members or profile variables
• Export members or profile variables