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 the workspace to add the process to your flowchart.

The process configuration dialog appears.

4.	On the Source tab, select an input cell, a single table, or a strategic segment from the Input list. If you select a strategic segment, associate it with a table by selecting a table from the Select Based On list.

5.	Specify the records to use as input:

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

Select Records With to select records 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: Click in the Field Name, Oper., Value, and And/Or column cells to select values to build your query. This method 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 and string functions.

You can select fields 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 Campaign Generated Field, you must qualify the field name using the following syntax: <table_name>.<field_name>.

7.	On the Extract tab, use the Target Data Source field to select an output location:

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

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

8.	Select fields from the list of Candidate Fields, and add them to the Fields to Extract list. Use the controls to remove or reorder fields. For information about the fields on the Extract tab, see Extract tab reference.

9.	Perform any of the following optional tasks:

Click Profile to preview a list of values for the selected field. SeeProfiling fields.

Click Derived Fields to create a variable in the list of candidate fields. SeeAbout derived fields

Click More to exclude duplicate IDs from the output. SeeSkipping duplicate IDs in process output.

10.	Optionally, use the Cell Size Limit tab to limit the number of IDs generated by the process.

See Limiting the size of output cells.

11.	Optionally, use the Dimension tab to add existing dimension tables to the extract table and specify the key fields to join on. The extract table becomes a base table for the selected dimension tables and can be used in downstream processes.

12.	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 about linking to target cells, see To link flowchart cells to target cells using the process configuration dialog.

13.

Click OK.

You can test run the process to verify that it returns the results you expect.