To create a new user table through an output process
From the output processes (Snapshot, Call List, and Mail List) in the Export drop-down list, you can create new user tables.
1.
2.
In the Export to drop-down list, select New Mapped Table.
The New Table Definition window opens.
3.
Select Base Record Table, Dimension Table, or General Table. Typically in this process, you would export the data to a new base table in an existing flat file or database. If you need to read the exported data back into Campaign, you must export it as a base table.
4.
Click Next.
5.
6.
a.
b.
Click Next.
c.
Select the Source Table Fields to export to the new table or file. You can select from Campaign Generated Fields, the audience-level identifier, and fields from the input cell. Use the Add, Remove, Up, and Down buttons to define fields in the New Table Fields list.
d.
Click Next.
e.
Specify a Database Table Name and IBM® Campaign Table Name for the new table.
f.
g.
Click Next.
h.
Select the Audience Level for the new table and specify the audience level field in the new table.
i.
Click Next.
j.
k.
Click Next.
l.
m.
Click Finish.
7.
a.
Click Next.
b.
Select Fixed-Width Flat File or Delimited File, then specify the Settings fields appropriately.
c.
Click Next.
d.
Select the Source Table Fields to export to the new table or file. You can select from Campaign Generated Fields, the audience-level identifier, and fields from the input cell. Use the Add, Remove, Up, and Down buttons to define fields in the New Table Fields list.
e.
Click Next.
f.
Select the Audience Level for the new table and specify the audience level field in the new table.
g.
Click Next.
h.
i.
Click Next.
j.
k.
Click Finish.