Creating new user tables through an output process
You can create new user tables by exporting data from an output process, such as Snapshot, Call List, or Mail List.
Procedure
- While editing a flowchart, open the output process from which you want to create the new user table.
-
In the Export to list, select New mapped
table.
The New Table Definition window opens.
- Select Base record table, Dimension table, or General table. Typically, you would export the data to a new base record table in an existing flat file or database. If you need to read the exported data back into Unica Campaign, you must export it as a base record table.
- Click Next.
- Select Create new file or Create new table in selected database.
-
If you selected Create new table in selected database:
- Select the database in which to create the table, then click Next.
- Select the Source table fields to export. You can select Unica Campaign Generated Fields, the audience-level identifier, and fields from the input cell. Use the Add, Remove, Up, and Down buttons to specify and order fields in the New table fields list.
- Click Next.
- Specify a Database table name and Unica Campaign Table name for the new table.
- Optional: Select the new table fields and modify the Unica Campaign Field name.
- Click Next.
- Select the Audience level for the new table and specify the audience level field in the new table, then click Next.
- Optional: Use Add to select additional audience levels for the new table, then click Next.
- Define profiling for the new table. Profiling enables users to see and select table values when editing a flowchart or building a query. See Configuring profiling when mapping user tables.
- Click Finish.
-
If you selected Create new file:
- Click Next.
- Select Fixed-Width flat file or Delimited file, specify the Settings fields appropriately, and click Next.
- Select the Source table fields to export to the new table or file. You can select Unica Campaign Generated Fields, the audience-level identifier, and fields from the input cell. Use the Add, Remove, Up, and Down buttons to specify and order fields in the New table fields list.
- Click Next.
- Select the Audience level for the new table, specify the audience level field in the new table, then click Next.
- Optional: Click Add to select additional audience levels for the new table, then click Next.
- Define profiling for the new table. Profiling enables users to see and select table values when editing a flowchart or building a query. See Configuring profiling when mapping user tables.
- Click Finish.