Merge Columns

Allows you to merge several columns into one custom category.

The merge columns tool in the Bunker's web UI gives you an ability to merge your source columns into a single column and you can assign that custom category as a key if needed.

You will find a merge columns option in normalise section either in ListView or spreadsheet view. Click on Merge columns 

Screenshot 2020-09-03 at 12.07.54

Select the columns you would like to merge and click Next

Screenshot 2020-09-03 at 12.13.00

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.

Screenshot 2020-09-03 at 12.17.09

When you click Next, it will take you to content template where you can define the content of your new custom column. 

Screenshot 2020-09-03 at 12.21.27

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

Screenshot 2020-09-03 at 12.25.59

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. 

Screenshot 2020-09-03 at 12.32.43

Next up

If you have successfully mapped your dataset, it's time to normalise and publish your dataset to make it available for queries.