Crossproduct worksheets

Crossproduct Worksheets

Use common sort keys in two worksheets to create two new worksheets that are the result of a Cartesian cross product transformation. Users specify the common sort keys and the carry along parameters or variables used to create the output worksheets.

For example, assume the following two datasets are mapped to a Crossproduct object:

Dataset 1:

  Period Data
  A       1
  A       2
  B       3
  B       4

Dataset 2:

  Phase Color
  X      R
  X      B
  Y      Y
  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:

  Period Phase Data
  A       X      1
  A       X      2
  A       Y      1
  A       Y      2
  B       X      3
  B       X      4
  B       Y      2
  B       Y      4

Worksheet BA:

  Period Phase Color
  A       X      R
  A       X      B
  A       Y      Y
  A       Y      V
  B       X      R
  B       X      B
  B       Y      Y
  B       Y      V

Use one of the following to add the 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.

Note: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.

Mappings panel

The Mappings panel allows users to specify which columns in a worksheet are involved in the worksheet transformation. Required input is highlighted orange in the interface.

Sort: Categorical variable(s) identifying individual data profiles, such as subject ID.
Carry Along: Variables or parameters from each worksheet that are used to create the cross product output worksheets.

Users can specify multiple sort keys and carry along values. It is also possible to select a sort key from only one input worksheet. That sort key is then applied to both output worksheets. Users can also choose no sort keys, in which case Phoenix assumes that a single profile is the sort key for both input worksheets.

Results

The Crossproduct Worksheets object generates two worksheets and one text file.

Worksheet AB: Combination of worksheet 1 and 2 sort keys, and worksheet 2 carry along values.

Worksheet BA: Combination of worksheet 2 and 1 sort keys, and worksheet 1 carry along values.

Settings: Text file containing input worksheets used and the options selected.