Show TOC

 XStep Parameters for Tabular Values Locate this document in the navigation structure

Use

If you want to reuse values from a table (repeated data requests) using XStep parameters, you must set the Table indicator in the parameter definition on the Parameter tab page. This XStep parameter is then valid for all values in a table column.

XStep parameters for tabular values can be:

  • Transferred to function modules, which can then process table parameters

  • Output in a different table in the PI sheet

Using XStep parameters for tabular values, you can also transfer the following values using the parameter enhancement:

  • Only the single row value of a table column

    In this case, you insert the supplement [1], [2], [3] and so on, after the parameter name for each table row, for example, PARAM1[1], PARAM1[2], PARAM1[3].

  • The sum of all the row values that are contained in the table column

    In this case, you insert the supplement [SUM] after the parameter name, for example, PARAM1[SUM].

  • The number of row values that are contained in the table column

    In this case, you insert the supplement [COUNT] after the parameter name, for example, PARAM1[COUNT].

Example

This graphic is explained in the accompanying text.

You have defined a table with three rows in an XStep. The rows contain material quantities amongst other things. In the subordinated XStep you want to calculate the average quantity of the material quantities that are contained in the table. Proceed in the following way:

  • You define the XStep parameter TAB1 with category Local in the higher-level XStep and set the Table indicator.

  • You define XStep parameter TAB2 in the subordinated XStep. You assign category Input and value assignment type Reference to TAB2 and set the Table indicator. You assign values to XStep parameter TAB2 using a reference to TAB1.

  • Using a calculation formula you can calculate the average value using the parameter enhancements [SUM] and [COUNT]. You can output the calculated value in the PI sheet.You must define the corresponding process instructions.

    See also: XStep Process Instructions for PI Sheets