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

  1. While editing a flowchart, open the output process from which you want to create the new user table.
  2. In the Export to list, select New mapped table.
    The New Table Definition window opens.
  3. 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.
  4. Click Next.
  5. Select Create new file or Create new table in selected database.
  6. If you selected Create new table in selected database:
    1. Select the database in which to create the table, then click Next.
    2. 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.
    3. Click Next.
    4. Specify a Database table name and Unica Campaign Table name for the new table.
    5. Optional: Select the new table fields and modify the Unica Campaign Field name.
    6. Click Next.
    7. Select the Audience level for the new table and specify the audience level field in the new table, then click Next.
    8. Optional: Use Add to select additional audience levels for the new table, then click Next.
    9. 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.
    10. Click Finish.
  7. If you selected Create new file:
    1. Click Next.
    2. Select Fixed-Width flat file or Delimited file, specify the Settings fields appropriately, and click Next.
    3. 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.
    4. Click Next.
    5. Select the Audience level for the new table, specify the audience level field in the new table, then click Next.
    6. Optional: Click Add to select additional audience levels for the new table, then click Next.
    7. 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.
    8. Click Finish.