- From Map and Calculate, select a Database.
- Select Create new table from the Table list.
- Enter a unique table name in New table name and select a New table type.
- To import the definition of an existing table:
- Hover over to display .
- Select , then specify the Database and Table.
- Select 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.
- To manually create a destination table, do any of the following:
Option Action Map a source column into the destination field - Select .
- Click in Select a field and select a field.
- Select to populate Column name, Column type, Length, and Precision based on the source field.
The source fields can be modified
- Select or clear Index, as needed.
- [Optional] Select to add more fields to the table.
- [Optional] Select to reorder columns.
Create a formula to populate the destination field - Select .
- Enter a Formula Name.
- Select a Type.
- In the Formula Builder, select the Fields, Functions, or Variables tabs and select options to create a formula.
- Select Save and Close.
- Select to populate Column name, Column type, Length, and Precision based on the source field.
The source fields can be modified
- Select or clear Index, as needed.
- [Optional] Select to add more fields to the table.
- [Optional] Select to reorder columns.
To remove a map column, select. - [Optional] Include a variable in a column:
Option Action Add a variable - Select .
- In Formula Builder, select Variables.
- By Rule Variables, select
- Complete variable information.
- Select Create Variable.
Edit a variable - Select .
- In Formula Builder, select Variables.
- Hover over a Rule Variable, then select .
- Update the variable information.
- Select Save Variable.
Delete a variable - Select .
- In Formula Builder, select Variables.
- Hover over a Rule Variable, then select .
- Select Yes.
- Select Create Table.
- Select Continue.