Populate the Tutorial Events Table | Vantage Analyst - Populate the Events Table - Teradata Analytic Apps

This tutorial uses an Events (TUTORIAL_CUSTOMER_EVENTS) from three datasets. You've already downloaded the sample data and added the tables to your database.

In this section, Vantage Analyst combines the data from the different sources into a single Events table. This is useful when your customer data comes from multiple sources.

If coding this by hand, you would need the following INSERT statements to map the correct columns from each of the source tables and manually build the Events table:

-- Insert Web event records
INSERT INTO TUTORIAL_CUSTOMER_EVENTS
SELECT web_cust_id as entity_id, page_ts as datestamp, web_page as event
FROM TUTORIAL_WEB;

-- Insert Transaction event records
INSERT INTO TUTORIAL_CUSTOMER_EVENTS
SELECT account_id as entity_id, tran_ds as datestamp, tran_cd as event
FROM TUTORIAL_TRANS;

-- Insert Support event records
INSERT INTO TUTORIAL_CUSTOMER_EVENTS
SELECT customer_id as entity_id, ticket_ds as datestamp, issue_cd as event
FROM TUTORIAL_SUPPORT;

You previously created these tables as part of Creating the Tables.

With Vantage Analyst workflows and rules, you can accomplish this without coding, and then automate the process to make sure you always have current data from each source.

Populate the Tutorial Events Table | Vantage Analyst - Populate the Events Table - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst Path Analysis Tutorial