Create a Rule | Vantage Analyst - Creating Rules to Populate the Events Table - Teradata Analytic Apps

Vantage Analyst workflows use rules to insert data into a table.

Select > Data Preparation > Rules.
Select Create New > Insert rule.
In the name field, type TUT_WEB_EVENTS.

This rule populates events from the TUTORIAL_WEB table to the TUTORIAL_CUSTOMER_EVENTS table.
On the Sources page, select the following:
Connection The Teradata-Vantage connection you created earlier

Database The database in which in which you added the sample data

Table TUTORIAL_WEB

After selecting the table, it moves to the Your selected sources area:
Select Continue.
On the Joins page, select Continue again.
Because there is only one table, you do not need to create a join. However, Vantage Analyst rules allow you to combine tables with different types of joins such as inner, outer, and cross joins.
On the Map and Calculate page, select the following:
Database The database in which you created the Events table

Table TUTORIAL_CUSTOMER_EVENTS
Click Select Table.
In the Map columns area, map each field from the source table to the destination table, as shown here:
Source table field Destination field

web_cust_id entity_id

page_ts datestamp

web_page event

Your map should look similar to the following:
Select Continue.
On the Filter page, select Continue again.
You can use filters to limit the data processed by a rule. However, you won’t need filters in this tutorial.
Select Save.
Select > Data Preparation > Rules to see your newly created rule.

Connection	The Teradata-Vantage connection you created earlier
Database	The database in which in which you added the sample data
Table	TUTORIAL_WEB

Database	The database in which you created the Events table
Table	TUTORIAL_CUSTOMER_EVENTS

Source table field	Destination field
web_cust_id	entity_id
page_ts	datestamp
web_page	event

Repeat the Creating Rules to Populate the Events Table process to create the following other insert rules:

TUT_TRAN_EVENTS rule
Source table field (TUTORIAL_TRANS)	Destination field (TUTORIAL_CUSTOMER_EVENTS)
account_id	entity_id
tran_ds	datestamp
tran_cd	event

TUT_SUPPORT_EVENTS rule
Source table field (TUTORIAL_SUPPORT)	Destination field (TUTORIAL_CUSTOMER_EVENTS)
customer_id	entity_id
ticket_ds	datestamp
issue_cd	event

The rules populate the integrated TUTORIAL_CUSTOMER_EVENTS table with data from web interactions, transactions, and support issues. Your list of rules should look similar to the following:

Create a Rule | Vantage Analyst - Creating Rules to Populate the Events Table - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst Path Analysis Tutorial