Mapping a base record table to an existing delimited file
Map a new base record table to make data accessible to processes in flowcharts. You can map a new base record table to an existing delimited file on the Unica Campaign server within your partition. The file must be located under your partition root.
Before you begin
Procedure
-
Use one of the following methods to open the New table definition - Select the table
type dialog:
- If you are editing a flowchart, open the Admin menu and select Tables, or
- If you are editing a flowchart, begin configuring a Select process, or
- Select Manage table mappings. , then click
- If necessary, select Base record table, then click Next.
- Select Map to existing file, then click Next.
- For File type, select Delimited file.
-
In the Settings section, check First row of data contains field names if
you want to automatically use the first row of data to define the fields of the base table.
You can override these values later.
- Select a Field delimiter to indicate which character separates each field in a row of data: TAB, COMMA, or SPACE.
-
Select the Qualifier that is used to indicate how strings are delimited
in the file: None, Single quote, or Double
quote.
This setting is important if you have a space-delimited file with spaces in field entries. For example, if you have a row of data such as: "John Smith" "100 Main Street", set the Field Delimiter to Space and set the Qualifier to Double quote so the record is correctly parsed as two fields (name and street address).
- Click Browse to select the Source file from within your partition directory.
- Define the fields for the new table:
Use the Add and Remove buttons to specify which Source table fields to include in the new table. By default, all fields in the file are listed.
Use the Up 1 and Down 1 buttons to adjust field order. Click the Field name column in the New table fields section to automatically sort column names alphabetically in ascending or descending order.
You can adjust the field type (Numeric or Text) and width, which are automatically detected based on the numRowsReadToParseDelimitedFile configuration setting. For example, if IDs are detected to be 2 characters wide, but you know that IDs can consist of up to 5 characters, increase the value to 5.
Important: If the width value is too small, an error may occur. - Click Next.
- Accept the defaults on the Specify table name and field information screen, or edit the Unica Campaign Table name field to change the name of the table as it will appear in Unica Campaign. You can also change the Unica Campaign Field name mapped to each source field name by selecting the field name and editing the text in the Unica Campaign Field name text box in the Edit selected field information section.
- Click Next.
- On the Specify the selected table's audience level and assign ID field(s) to it screen, select an Audience level from the 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.
-
Click Next.
The Specify additional audience levels screen opens.
- Optionally, you can specify one or more additional audience
levels contained in the base record table. Adding additional audience
levels allows users to use this table as a "switching table" to translate
from one audience level to another using the Audience process
in a flowchart.
- Click Add.
- Select an Audience level name.
- For each Audience field, match appropriate field(s) from the base table to the corresponding key(s) in the audience level.
- If each unique audience ID appears at most once in the current base table, check This audience level is normalized in this table.
- Click OK.
- Repeat steps a through e for each audience level that you want to add for the base table, then click Next.
- You can choose to pre-compute the distinct values and frequency counts for specific fields, or allow users to perform real-time profiling of data in the base record table.
- Click Finish.