Table_template_for_merged_worksheet

Table template for merged worksheet data

The steps to create a table template that uses data from two merged worksheets (e.g., merged PK data from an input worksheet and PK parameter estimates from a modeling output worksheet) are presented in this section. The process begins with the Default table type and uses the Merge Worksheets object.

This table template presents raw data at different sample times and PK parameters in columns, with a row for each subject or ID variable. It generates summary statistics for each unique combination of group and ID variable values. The two datasets must be merged using these group and ID variable values.

Import the source data into a project.

Add a Merge Worksheets object to the workflow.

Drag the dataset from the Data folder to the Merge Worksheets’ Mappings panel.

Merge the worksheets using common sort keys.

The variables mapped to the Sort context must match in both worksheets.

The variables do not need to have identical names, but they must be the same type of variable with overlapping sets of values. The variable values are used to merge values from both datasets.

A set of summary statistics is computed for each unique combination of Sort variable values.

Map other variables to be included in the table to the Included Column context.

Check the Carry Along Data For Like Sort Levels box.

Execute the Merge Worksheets object.

Add a Table object to the workflow.

Map the Merge Worksheets object’s Result worksheet to the Table object.

In the Table object’s Options tab, select Default in the Table Type menu.

Map the variables in the merged dataset to the appropriate contexts.

Specify any other table options and execute the Table object.