To extract data from a cell, single table, or strategic segment

1.	Within a campaign, open a flowchart for editing.

2.	Double-click the Extract process in the flowchart workspace.

3.	Click the Extract process in the palette, then click on the workspace to add the process to your flowchart.

The process configuration dialog appears.

4.	On the Source tab, use the Input list to choose the data source that you want to select from:

Select an input cell, a single table or a strategic segment from the Input list.

If you select a strategic segment as your input data source, associate it with a table by selecting a table from the Select Based On list.

5.	Specify the records to use as input. Select one of these options:

Select All Records to include all records in your input data source.

Select Records With to select only certain records from your input, based on criteria you define using queries.

6.	If you chose Select Records With, create a query using one of the following methods:

Point & Click: This is the default view. Click in the Field Name, Oper., Value, and And/Or column cells to select values to build your query. This tool provides the easiest way to create a query and helps to avoid syntax errors.

Text Builder: Use this tool to write raw SQL or use the provided macros. You can use the Query Helper within Text Builder to select IBM Unica macros, including logical operators, string functions, and so on.

7.	If you are constructing a query, select the fields you want to include in your query from the Available Fields list, including IBM® Unica Campaign Generated Fields and Derived Fields. For more information, seeCreating queries in processes.

If your query includes a table field that has the same name as a IBM® Unica Campaign Generated Field, you must qualify the field name using the following syntax: <table_name>.<field_name>. This syntax indicates that the table field will be used instead of the IBM® Unica Campaign Generated Field.

8.	On the Extract tab, select an output location.

To store the data in binary format, select Campaign Server.

To store the data in a uniquely-named table with a UAC_EX prefix, select an available database.

9.	Select fields to extract from the list of Candidate Fields.

Click Add to add selected fields to the list of Fields to Extract.

To remove fields from the list of Fields to Extract, select them and click Remove.

Use the Up 1 and Down 1 buttons to change the order of fields in the Fields to Extract list.

To change the default output name of a field to extract, select the field in the Fields to Extract list, click on the name in the Output Name column, then enter the new name.

For information about the fields on the Extract tab, see Extract tab reference.

10.	Perform any of the following optional tasks:

Profile an available field from a cell, table, or strategic segment, click Profile. For more information, seeProfiling fields.

Add a derived field to the list of candidate fields. See About derived fields

Specify that duplicate IDs are excluded from the output. SeeSkipping duplicate IDs in process output.

Limit the size of the output cell (that is, limit the number of IDs generated by the process). See Limiting the size of output cells.

Click the General tab to modify the Process Name, Output Cell names, or Cell Codes, link to a target cell, or enter a Note about the process.

For information on linking to target cells, see To link flowchart cells to target cells using the process configuration dialog.

11.

Click OK.

The process is configured and appears enabled in the flowchart. You can test run the process to verify that it returns the results you expect.