Creating a Destination Table - Teradata Analytic Apps - Vantage Analyst

Vantage Analyst with Machine Learning Engine User Guide
Product
Teradata Analytic Apps
Vantage Analyst
Release Number
1.1
Published
December 2019
Language
English (United States)
Last Update
2020-08-06
dita:mapPath
ezh1551894635141.ditamap
dita:ditavalPath
wsp1565965728073.ditaval
dita:id
B035-3805
lifecycle
previous
Product Category
Teradata Vantage™
  1. From Map and Calculate, select a Database.
  2. Select Create new table from the Table list.
  3. Enter a unique table name in New table name and select a New table type.
  4. To import the definition of an existing table:
    1. Hover over "" to display "" .
    2. Click "" , then specify the Database and Table.
    3. Click IMPORT COLUMNS.

      The imported columns are appended to any columns that have already been specified, and existing columns are not overwritten. If you want to overwrite, remove the existing columns before or after importing.

      Imported definitions can be edited after import.

  5. To manually create a destination table, do any of the following:
    Option Steps
    Map a source column into the destination field
    1. Select "" > Field.
    2. Click in Select a field and select a field.
    3. Click "" to populate Column name, Column type, Length, and Precision based on the source field.

      The source fields can be modified

    4. Select or clear Index, as needed.
    5. [Optional] Click "" to add more fields to the table.
    6. [Optional] Click "" to reorder columns.
    Create a formula to populate the destination field
    1. Select "" > Formula.
    2. Enter a Formula Name.
    3. Select a Type.
    4. In the Formula Builder, click the FIELDS, FUNCTIONS, or VARIABLES tabs and select options to create a formula.
    5. Click SAVE AND CLOSE.
    6. Click "" to populate Column name, Column type, Length, and Precision based on the source field.

      The source fields can be modified

    7. Select or clear Index, as needed.
    8. [Optional] Click "" to add more fields to the table.
    9. [Optional] Click "" to reorder columns.
    To remove a map column, select "" > Remove.

  6. [Optional] Include a variable in a column:
    Option Action
    Add a variable
    1. Select "" > Formula.
    2. In Formula Builder, click VARIABLES.
    3. By Rule Variables, click "" .
    4. Complete variable information.
    5. Click CREATE VARIABLE.
    Edit a variable
    1. Select "" > Formula.
    2. In Formula Builder, click VARIABLES.
    3. Hover over a Rule Variable, then select "" > Edit.
    4. Update the variable information.
    5. Click SAVE VARIABLE.
    Delete a variable
    1. Select "" > Formula.
    2. In Formula Builder, click VARIABLES.
    3. Hover over a Rule Variable, then select "" > Delete.
    4. Click Yes.
  7. Click CREATE TABLE.
  8. Click CONTINUE.