Create a union table

About union tables

After creating a custom table, you can merge its data with other queries to create a union table. When merging a custom table with an already existing query, the fields of the custom table whose name matches those in the query are automatically merged. The rest of them will appear as not assigned, and you can merge them with the custom table fields of the same type.

The following diagram represents how the merging process works:

Open

What permissions do I need?

To use this feature you need two different permissions:

• View level of the Finders permission. This permission is required to access a search, which is necessary to create a union table.

• The Custom tables permission. This permission is required to enable the custom table options in the toolbar menu of the search window.

Open

Creating your union table

To merge a custom table with a query:

Accessing your union table

The new union table will appear in Data Search → Explore Your Data.