Clear Prior Data from the Tutorial Tables | Vantage Analyst - Clearing Prior Data - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst Path Analysis Tutorial

Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.4.1
Published
May 2022
Language
English (United States)
Last Update
2022-05-09
dita:mapPath
val1593625364475.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
dita:id
val1593625364475
lifecycle
previous
Product Category
Teradata Applications

The first thing the new workflow should do is clear any prior data from the table. To accomplish this, we can use an SQL node, which allows you to submit any query to Vantage.

  1. Select and drag "" to the canvas.

    Dragging SQL

  2. In the Properties panel,do the following:
    Name Type Clear Prior Events.
    Connection Select the Teradata-Vantage database connection that you created earlier.
  3. Double-click the SQL node and type the following code in the SQL Code window:
    delete from tutorial_customer_events;
    Tip: You can also enter the code by selecting the node then selecting Edit, located at the bottom of the Properties panel.

    SQL code

  4. Select Save SQL.
  5. To connect the SQL node to the workflow, select and drag from the connector dot in the Start node to the Clear Prior Events (SQL) node.
Your workflow should look similar to:

Workflow showing SQL node

The error you’re seeing on the SQL node indicates that you have an incomplete workflow with no success path. You'll fix that by adding the remaining items to the workflow.