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

Within a campaign, open a flowchart for editing.

Drag the Extract process from the palette to your flowchart.

Double-click the Extract process box in the flowchart.

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.

Specify the records to use as input:

Choose Select All Records to include all records from the input data source.

Choose Select Records With to select records by doing a query.

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

For complete instructions, see Creating queries in processes.

Point & Click: Click in the Field Name, Oper., and Value cells to select values to build an expression. Use And/Or to combine expressions. 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 Formula Helper within Text Builder to select supplied macros, including logical operators and string functions.

With either method, you can select fields from the Available Fields list, which includes IBM® Campaign Generated Fields and Derived Fields.

If your query includes a table field that has the same name as a Campaign Generated Field, you must qualify the field name. Use the following syntax: <table_name>.<field_name>

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

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

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

On the Extract tab, select fields from the list of Candidate Fieldsand add them to the Fields to Extract list. Use the controls to remove or reorder fields. For information about using the Extract tab, see Extract tab reference.

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

See Limiting the size of output cells.

10.

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.

11.

Use the General tab as follows.

Process Name: Assign a descriptive name. The process name is used as the box label on the flowchart. It is also used in various dialogs and reports to identify the process.

Output Cell Name: This name matches the Process Name by default. It is used in various dialogs and reports to identify the output cell (the set of IDs that the process retrieves).

(Optional) If you click Link to Target Cell and you see a list of target cells (defined in the Target Cell Spreadsheet for the current campaign), you can select one. The cell name from the TCS now displays in the Output Cell Name field.

See About the target cell spreadsheet. Also see To link flowchart cells to target cells using the process configuration dialog.

Cell Code: The cell code has a standard format that is determined by your system administrator and is unique when generated

See Changing the cell code.

Note: Describe the purpose or result of the process. Common practice is to reference the selection criteria.

12.

Click OK.

The process is now configured. You can test run the process to verify that it returns the results you expect.