Row Keys and Column Keys 

Use

When you compare the data of several recipes, formulas, or substances using the Recipe Comparison, Formula Comparison, or Substance Comparison output variants, you have to define a row key and a column key so that the system can perform the comparison. In addition, defining a row key and column key in the output enables you to arrange data clearly in tables.

Features

In the output layout of the output variant you use the following indicators and output objects to control how the data is arranged in the output tables:

·        You use the Column Key indicator to specify which output object controls how the data is arranged in columns and appears as the title of the columns.

·        You use the Row Key indicator to specify which output object controls how the data is arranged in rows and appears first in the rows in the table.

If you set the Row Key indicator when comparing input and output materials for the material description, the system arranges the input and output materials alphabetically in rows according to the material description.

·        You use the Generic Row Key output object to influence the order in which the rows are output. If you specify that this output object comes first in the output layout, and set the Output and Row Key indicators, the system outputs the rows in the same sort sequence as they appear on the tab pages. This means that you overwrite the alphabetical sort sequence of the output objects, for example. However, the system always outputs the outputs below the inputs.

·        You use the Generic Column Key output object to influence the order in which the columns are output. If you specify that this output object comes first in the output layout, and set the Output and Column Key indicators, the system outputs, for example, the reference recipe, reference formula, or reference substance in the first column in the comparison output, even if this would not appear first in alphabetical order.

Example

In the examples that follow, the formulas 19279 and 19281 are compared using the Formula Comparison output variant:

·        Comparing header data

To achieve the following output, the Output indicator was set in the output layout for the following output objects under  Header Data ®  Formula:

¡        Formula

¡        Value Desc.

¡        Value

The Column Key indicator was also set for Formula and in addition, the Row Key indicator was set for Value Desc.. A formatting profile was chosen, the Format and Display Legend indicators were set, and the formula 19279 was entered as a reference formula in the output parameters. Since this formula is the reference formula, you do not have to output the Generic Column Key output object because formula 19279 is output before formula 19281.

When the header data is compared, numerical values are treated as texts which means that the system only shows that the values are different and not whether a value is larger or smaller than the comparison value.

·        Comparing material quantities

To achieve the following output, the Output indicator was set for the following objects in the output layout under  Input and Output:

¡        Formula

¡        Material

¡        Primary output

¡        Quantity

¡        Unit of measure

The Column Key indicator was also set for Formula and the Row Key indicator was set for Material. A formatting profile was chosen, the Format and Display Legend indicators were set, and the formula 19279 was entered as a reference formula in the output parameters.

Only set the Row Key indicator for the objects that are to be compared in the formulas and are identical in the formulas, for example, for the material. Otherwise, the system may interpret whole rows as being different although they are not: If, for example, you also define the item number as a row key, as well as the material, and the item number is different for a material that has identical quantities in the formulas to be compared, the quantities and all other cells in the row are marked as different. However, if you only want to define the material as a row key, only the item number is marked as different and not the identical quantities.

If a value was entered in one formula but not in another, the value is only marked as different when the formula data is compared, and not when other views are compared. The value is not formatted separately there.