Allows you to merge several columns into one custom category.
You will find a merge columns option in the normalize section either in List view or Spreadsheet view. Click on Merge columns.
Select the columns you would like to merge and click Next.
Now, give a name to your custom column. You can select this custom category as a key to join with other datasets, providing the custom key exists in the linked datasets.
When you click Next, it will take you to content template where you can define the content of your new custom column.
You can add custom text in your custom category. In the above example, we have added "MAID" prior to Mobile Advertising ID and "COOKIE" prior to Cookie ID to form a custom category.
By default, the platform will drop the columns used in merging after it merged into a new custom category. In the above example, the platform dropped Device ID and Cookie source columns after it merged them into a new custom category.
If you want to keep the columns you are using for merging, then assign those source columns to Global Schema Category before merging.
You can search for unassigned columns, hover the mouse over a column and then click on the plus (+) sign to assign the selected column to a category. To remove a category, select Unassign from the Actions menu.
If you have successfully mapped your dataset, it's time to normalize and publish your dataset to make it available for queries.