Data Mapping

Data mapping is the process of associating a dataset with an operational object so that objects can use the data in an analysis or other function. Data mapping in Phoenix is as simple as dragging a dataset from the Data folder to an object’s input, or using the Select Object dialog to select a dataset.

There are multiple types of data mapping in Phoenix:

Phoenix can complete context mappings if a column header in a worksheet matches the context name in an operational object. The Global Contexts and Context Association panels in the Prefer­ences dialog can be used to automatically associate columns in a dataset with contexts in an opera­tional object. For example, Phoenix can be set to map a concentration column named conc to an operational object’s concentration context.

Mapping a dataset to an operational object

Every operational object includes a data input panel in the Setup tab that is used to identify how input variables are used in an operational object.

Most primary data input panels contain two tabs: the Mapping tab (where dataset columns are mapped to an object’s inputs) and a sort order tab (allows users to sort dataset columns). The Table, NONMEM, PsN, R, SAS, and SigmaPlot objects only have a Mappings panel.

Users can map a dataset or other worksheet to almost any item in the Setup tab list using the instruc­tions listed below. Note that the R and SAS Shell objects must have a script mapped to them before their inputs are defined. The PsN Shell object must have at least one model mapped to it before the input can be defined.

To map a dataset using the data mappings panel

In the data mappings panel, click icon_showsources_1.png (Show Sources icon).

In the dialog, click the (+) sign next to the Data folder.

Select a dataset and click Select.

Or use the pointer to drag a dataset from the Data folder to the Mappings panel.

To map a dataset using the Diagram tab

Select the Workflow object in the Object Browser.

In the Diagram tab, click down_arrows_1.png to expand the object box.

Click the (+) sign next to Inputs.

Drag the dataset from the Data folder to the primary data input.

The line between the External Sources box and the object box represents the data mapping.

To map a dataset using the “Send To” menu option

Select the object in the Object Browser to return to the Setup tab.

Right-click an imported worksheet and select Send To > <object group> > <operational object>.

The Send To command inserts the new object into the Workflow with the right-clicked worksheet already mapped as the input source.

Mapping results to an operational object

The results worksheet of any operational object can also be mapped to another operational object.

To map results from the Setup tab

Click icon_select_source_1.png (Select Source icon) in the operational object’s Setup tab.

In the dialog, click the (+) signs to expand the menu tree.

Select the results worksheet and click Select.

To map results from the worksheet

Right-click a results worksheet and select Send To > <object group> > <operational object>.

Mapping context associations

Context associations are inputs to an operational object. Contexts that must have data mapped to them so the object can perform its function are shaded orange. Most items in an operational object’s Setup list have a Mappings panel that allows users to match columns in a dataset to inputs in an operational object.

Column headers in the dataset are displayed on the left side and context associations for the opera­tional object are displayed across the top.

MaincontextNCAmodel200.png 

Context associations for NCA model 200

Select the option button to connect the input dataset column containing the data (row) to the corre­sponding context (column).

Repeat for each item in the Setup tab list that requires mapping data to inputs.


Last modified date:7/9/20
Certara USA, Inc.
Legal Notice | Contact Certara
© 2020 Certara USA, Inc. All rights reserved.