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

Vantage Analyst User Guide

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
ufz1626905554941.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
dita:id
B035-3805
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.