Stacker

Primarily used to convert unstacked datasets, like the Final Parameters Pivoted worksheet output from a PK or NCA model. The Stacker object moves values stored in column headings into rows. When data is stacked by parameter, the separate parameter columns are “stacked” in one column and the parameter values are arranged beside each parameter in the stacked column.

Use one of the following to add the worksheet object to a Workflow:

Right-click menu for a Workflow object: New > Data Management > Stacker.

Main menu: Insert > Data Management > Stacker.

Right-click menu for a worksheet: Send To > Data Management > Stacker.

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

Options tab

Results


Mappings panel

Mappings panels identify how input variables are to be used. Map the data by dragging the dataset from the Data folder to the Setup tab or use the icon_select_source icon in the Setup tab.

Once a dataset is mapped, use the option buttons in the Mappings panels to assign the columns in the dataset to the appropriate context associations. Required context mappings are colored orange.

Carry: Variable(s) to copy to the output worksheets.

Stack: Data types to stack in a single column. The values in each stacked column are then placed beside each column header in a separate column.

Note that the order in which the Carry columns are selected is the order they will appear in the output worksheet.

Options tab

StackerOptstab

In the Stacked Column Name field, type a name for the output column that contains the stacked data.

In the Estimate Column Name field, type a name for the output column that contains the values that are matched with the stacked data.

Check the Include Missing Values box to carry empty rows through to the results worksheet. This allows keeping track of records for which a parameter (e.g., a PK parameter) could not be calculated for some reason.

In the Unit Column Name field, type a name for the output column that contains the units that are matched with the stacked data.

Clear the Use Units checkbox if the input worksheet does not use units or units are not needed in the output.

Results

Select the Results tab to view the output. The object generates one worksheet and one text file.

Stacked: The stacked data types and their associated values and units, if any.

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


Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.