Join Sources | Vantage Analyst - Joining Sources - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst User Guide

Teradata Analytic Apps
Vantage Analyst
Release Number
May 2022
English (United States)
Last Update
Product Category
Teradata Applications
After selecting sources, use the Join step to specify how the tables you selected relate to each other.
  1. [Optional] Arrange tables in the preferred join order.
    The primary table, which must be located in the leftmost table, is determined by being the first source node.
  2. From Joins, create a connection between two tables by clicking on one node and dragging to the other table.
  3. From Edit Join, select the join type, fields that are relevant to both tables, and operators.
    Option Action
    Create more than one row of join conditions Select ""
    Delete a row of join conditions Select ""
    Edit a different join Select the join

    Edit Join options
  4. Create join conditions between each column, as needed.
  5. Select Save Join.
  6. [Optional] You can change the order in which multiple joins are evaluated.
    Numbers next to join icons indicate evaluation order.
    1. Select "" in the top bar.
    2. Select "" to change order.
    3. Select Save Join Sequence.
  7. [Optional] Select or clear the check box for the columns in each table.

    Selecting only needed columns is useful in steps where a list displays available fields for selection.

  8. Select Continue.