Setting Up Related Table

Related table setup is a one-time step you can complete by following these steps:

1. Related tables must be created in relation to an existing schema. Click the + button on any existing table and Select related table.

1. Sortment prompts you to select a table in your data warehouse.

1. Enter a name for your related table. Use something that helps you identify it easily later.

2. Optionally, enter a description.

3. Choose the Primary Key column in your related table.

4. Click Next.

1. Label the fields in your events table. These can be used to filter on events data in Audiences.

1. Define the events relationship. Select the relationship's cardinality: 1:1, 1:many, or many:1. In most cases, primary tables have a 1:many relationship with events.

2. Click Save to add the table to your schema.