5.
|
Use the Method tab to specify whether to include or exclude input cells during the merge. Select a cell in the Input list, and add it to one of the following lists:
|
|
Records to Include: The IDs in the cells that you add to this list are combined into one list of unique IDs.
|
|
Records to Exclude: The IDs in the cells that you add to this list are not included in the merged output. For example, use this option to exclude Opt Outs.
|
6.
|
|
Merge/Purge on Include: This option produces a list of unique IDs that exist in at least one input cell. Duplicate IDs are included only once. This method uses a logical "OR" or "ANY." For example: Include customer A if that customer is in either the Gold.out cell OR the Platinum.out cell.
|
|
Match (AND) on Include: Include only those IDs that exist across all input cells. This method uses a logical "AND" or "ALL." For example: Include customer A only if that ID exists in both the Gold.out cell AND the LoyaltyProgram.out cell. This option is useful when you want to include customers that meet multiple criteria. If an ID does not exist in all of the Merge process input cells, the ID is not included.
|
7.
|
8.
|
a.
|
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.
|
b.
|
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 produces).
|
c.
|
(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.
|
d.
|
Cell Code: The cell code has a standard format that is determined by your system administrator and is unique when generated
|
e.
|
Note: Describe the purpose or result of the process. For example, indicate which records you are including or excluding.
|
9.
|
Copyright IBM Corporation 2015. All Rights Reserved.
|