Multiply Process Object

The Integrator Multiply process object takes subsets of records and generates additional records which are all the possible binary combinations of the input rows. For example, this process allows transaction sales data to be loaded in Integrator and used to generate other rows which connect different items in the same transaction. The process is similar to matrix multiplication of a column with values of itself.

Multiply Attributes

Attribute	Type	Description
process_type (required)	String	Identifies the object as a Multiply process object. The value of this string is "multiply".
input (required)	String	Defines the object from which the data flow is arriving.
break_column	String	Defines the name of the column used to break the input flow into subsets of rows. Only rows that have equal values for the break column are multiplied together. Either the attribute break_column or break_columns must be included. They are mutually exclusive. NOTE: This attribute is Break in Visual Integrator.
break_columns	Array of Strings	Defines the names of the columns used to break the input flow into subsets of rows. Only rows that have equal values for all of the break columns are multiplied together. Either the attribute break_column or break_columns must be included. They are mutually exclusive. NOTE: This attribute is Break in Visual Integrator.
multiply_columns	Array of Sub-objects	Defines the existing and new columns that will be used to form combinations. Each sub-object will define a source_column and a new_column (see two following items). At least one sub-object is required. NOTE: This attribute is Multiply New Column in Visual Integrator.
source_column	String	Defines the name of the source column. NOTE: This attribute is Source Object in Visual Integrator.
new_column	String	Defines the name of the new column that will hold the combination values from the source_column. NOTE: This attribute is Multiply New Column in Visual Integrator.
trace_after	Sub-object	Traces data flows leaving the specified object, which makes debugging scripts easier. This is equivalent to adding a Trace process object immediately after the current object. See Embedded Trace Object for more on using trace sub-objects.
trace_before	Sub-object	Traces data flows entering the specified object. This is equivalent to adding a Trace process object immediately before the current object. See Embedded Trace Object for more on using trace sub-objects.