Workspace Node: Cartesian Variables - Specifications Tab

The Cartesian Variables workspace node can be accessed from the Feature Finder, ribbon bar, or Node Browser. Double-click the node to display the specifications dialog box.

The Cartesian method of merging files creates a cross product of the variables. Every combination of every case will be created.

For example:

File 1:

SEAT DYNAMO
DOWN OFF
UP ON

File 2:

GEAR TIRES
MEDIUM HARD
LOW SOFT

Result:

SEAT DYNAMO GEAR TIRES
DOWN OFF MEDIUM HARD
DOWN OFF LOW SOFT
UP ON MEDIUM HARD
UP ON LOW SOFT

A possible application of a Cartesian merge is to generate an experimental design spreadsheet.

Element Name Description
Output In this group box, select the variables to merge from the two data files.
File 1 Variables Click this button to display a variable selection dialog box containing variables from the first data file; select the desired variables for the output file.
File 2 Variables Click this button to display a variable selection dialog box containing variables from the second data file; select the desired variables to merge into the output file.
Options

See Common Options.

OK Click the OK button to accept all the specifications made in the dialog box and to close it. To view the new spreadsheet, click the icon on the lower-right corner of the Concatenate Variables node.

See also, Home tab.