Allows you to merge several columns into one custom category.
You will find a merge columns option in normalise section either in ListView 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 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.
If you have successfully mapped your dataset, it's time to normalise and publish your dataset to make it available for queries.