Use common sort keys in two worksheets to create two new worksheets that are the result of a Cartesian cross product transformation. Common sort keys and the carry along parameters or variables used to create the output worksheets are identified.
For example, assume the following two datasets are mapped to a Crossproduct object:
Dataset 1 | Dataset 2 | ||
|---|---|---|---|
Period | Data | Phase | Color |
A | 1 | X | R |
A | 2 | X | B |
B | 3 | Y | Y |
B | 4 | Y | V |
If Period and Phase are mapped to Sort, and Data and Color are mapped to Carry Along, then the output worksheets look like this:
Worksheet AB | Worksheet BA | ||||
|---|---|---|---|---|---|
Period | Phase | Data | Period | Phase | Color |
A | X | 1 | A | X | R |
A | X | 2 | A | X | B |
A | Y | 1 | A | Y | Y |
A | Y | 2 | A | Y | V |
B | X | 3 | B | X | R |
B | X | 4 | B | X | B |
B | Y | 2 | B | Y | Y |
B | Y | 4 | B | Y | V |
Use one of the following to add the worksheet object to a Workflow:
Right-click menu for a Workflow object: New > Data Management > Crossproduct Worksheets.
Main menu: Insert > Data Management > Crossproduct Worksheets.
Right-click menu for a worksheet: Send To > Data Management > Crossproduct Worksheets.
To view the object in its own window, select it in the Object Browser and double-click it or press ENTER. All instructions for setting up and execution are the same whether the object is viewed in its own window or in Phoenix view.
Additional information is available for the following topics:
Mappings panels identify how input variables are to be used. Map the data by dragging the dataset from the Data folder to the Setup tab or use the 
icon in the Setup tab.
Once a dataset is mapped, use the option buttons in the Mappings panels to assign the columns in the dataset to the appropriate context associations. Required context mappings are colored orange.
Sort: Categorical variable(s) identifying individual data profiles.
Carry Along: Variable(s) to copy to the output worksheets.
Multiple sort keys and carry along values can be specified. It is also possible to select a sort key from only one input worksheet. That sort key is then applied to both output worksheets. If no sort keys are chosen, Phoenix assumes that a single profile is the sort key for both input worksheets.
Select the Results tab to view the output. The object generates two worksheets and one text file.
Worksheet AB: Combination of worksheet 1 and 2 sort keys, and worksheet 2 carry alongs.
Worksheet BA: Combination of worksheet 2 and 1 sort keys, and worksheet 1 carry alongs.
Settings: Text file containing input worksheets used and the options selected.