1.0 - Creating a Destination Table - Vantage Customer Experience

Vantage Customer Experience User Guide

prodname
Vantage Customer Experience
vrm_release
1.0
category
User Guide
featnum
B035-3800-099K
  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 or Data Source 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 or Data Source 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 or Data Source Variable, then select "" > Delete.
    4. Click Yes.
  7. Click CREATE TABLE.
  8. Click CONTINUE.