You map a new base record table to make data accessible to processes in flowcharts.
1.
2.
3.
4.
5. In the Settings section of the window, check First Row of Data Contains Field Names if this is the case.
6. Select the Field Delimiter (this is the character used to separate each field in a row of data): TAB, COMMA, or SPACE.
7. Select the Qualifier used to indicate how strings are delimited in the file: None, Single Quote, or Double Quote.This is important if you have a space-delimited file with spaces as part of a field entry. In this case, the field must be enclosed in quotation marks so the embedded spaces are not interpreted as field delimiters. For example, if you had a row of data such as: “John Smith” “100 Main St.”, with the delimiter as SPACE and Qualifier set to NONE, Campaign would parse this as five different fields (“John” as the value of the first field, “Smith” as the second, “100” as the third, and so forth). If the qualifier is set to Double Quote, then this record is correctly parsed as two fields (name and street address).
8. You use the Add, Remove, Up 1 and Down 1 buttons to specify the Source Table Fields that are included in the new table and their order. Click on the Field Name column in the New Table Fields section to automatically sort column names alphabetically in ascending (or descending) order.
10.
11. Accept the defaults, or edit the Unica Table Name field to change the name of the table as it will appear in Campaign. You can also change the Unica Field Name mapped to each source field name by selecting the field name and editing the text in the Unica Field Name text box in the Edit Selected Field Information section.
12.
13. Select an Audience Level from the drop-down list. The Audience Fields list is automatically populated. You must select a field in the new base table that is the corresponding key for each listed entry.
14.
15.
a.
b.
c. For each Audience Field, match appropriate field(s) from the base table to the corresponding key(s) in the audience level.
d. If the selected audience level is normalized (that is, each unique audience ID appears at most once in the current base table), check This audience level is normalized in this table.
e.
f.
17.
IBM Unica Campaign
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|