Extract tab reference

Use the fields on the Extract tab when you configure an Extract process in a flowchart.

Table 1. Fields on the Extract tab



Target data source

Location to which the output from this process will be written. The Unica Campaign Server and any other data sources to which you are connected are available in the Target data source drop-down list.

Candidate fields

List of fields available to extract, including field name and data type, based on your input data source. To see the list of fields, you may need to click the arrow next to an item to expand the item.

If your input source is a landing page in Unica Deliver, each field name is an attribute of the landing page. If the attribute contains special characters or spaces, it is converted to a valid field name. Data types of all landing page attributes are listed as text.
Note: Schema object names are limited to 30 characters. Restrict your attribute names to 30 characters or less to produce valid column names for extracted output.

Fields to extract

Fields that you chose to extract from the Candidate fields list. The Output name defaults to the field name in the Fields to extract column.

If you change the Output name, you can use any combination of letters and numbers. Do not use spaces, hyphens (-), periods (.), slashes (/ or \), or any special characters.


Click Profile to preview a list of values in the selected candidate field. Profiling is not available for Unica Deliver landing page attributes.

Derived fields...

Click Derived fields... to create a variable in the list of candidate fields. Derived fields are variables that do not exist in a data source and are created from one or more existing fields, even across different data sources.


Click More... to open the Advanced settings dialog. This dialog includes the option to exclude duplicate IDs from the output and specify how Unica Campaign identifies duplicates.