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.
You can map the exported data to a base or general table. Typically in this process, you would select to 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.
1.
While editing a flowchart, open the output process from which you want to create the new user table.
2.
In the Export to drop-down list, select New Table.
The New Table Definition window opens.
3.
Select Base Record Table or General Table.
4.
Click Next >.
5.
Select Create New File or Create New Table in Selected Database.
6.
If you select to create a new database table:
a.
Select the database in which to create the table.
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 Unica Table Name for the new table.
f.
Optionally, select the new table fields and modify the Unica Field Name.
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.
Optionally, select additional audience levels for the new table by clicking Add.
k.
Click Next >.
l.
Define profiling for the new table. For more information, see Profiling values and counts.
m.
Click Finish.
7.
If you select to create a new file:
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.
Optionally, select additional audience levels for the new table by clicking Add.
i.
Click Next >.
j.
Define profiling for the new table. For more information, see Profiling values and counts.
k.
Click Finish.
Copyright IBM Corporation 2012. All Rights Reserved.