Overview and Quickstart
Dataset Mapper is a Formedix ryze plugin which can be used to generate the mapping file used in data transformations. Dataset Mapper extends a define.xml file with mapping commands used to configure an Extract, Transfer, Load (ETL) system.
- For an example of how you might map proprietary datasets to SDTM, see Managing Proprietary Datasets.
Dataset Mapper can be used to map one variable to another. You can use it to map from a source dataset to a target dataset, for example, mapping variables from your EDC dataset to a standard SDTM dataset. Dataset Mapper can also be used to perform operations on data, for example, to change strings or to compute other data.
This quickstart guide describes how to upload a source dataset and map variables to the correct standard for submission.
Enable the Plugin for your Repository
Dataset Mapper must be enabled by an administrator to be available in your repository.
To enable the plugin for your repository, go to the Plugins section under Admin > Repository > Plugins.
Add your Source Dataset
- From your study, click Upload Datasets from the toolbar. In this example, we’ll use the sample demographics dataset above (DM Source.xml) as a guide.
- Choose a name for the asset group that is created (whenever you upload a dataset, a new asset group is created)
- The uploaded dataset should now appear in the study as a new Asset Group.
Add your Target Dataset
In this example, we’ll map some erroneous variables in the source dataset to the SDTM-IG 3.3 standard. This standard must be available in your library, see Published Standards.
- Click Associate Library and add the SDTM-IG 3.3 standard
- Create a new Asset Group for the Target Dataset and open the new Asset Group
- From the new Asset Group, click Import Assets and import the Demographics Dataset from SDTM-IG 3.3.

Add the Plugin to the Target Asset Group
Plugins are added at the Asset group level of a standard or study, see Using Plugins for more information.
- From the target Asset Group, click the Asset Group Properties icon
- Add the Dataset Mapper Plugin to the target Asset Group
Map the Target Dataset to the Source Dataset
Before we map individual variables, we must first map the dataset.
- From the Target dataset, click edit Dataset
- Open the Plugin Properties tab and go to Dataset Mapper properties
- Add the Source Dataset by specifying the Source Dataset Identifier.
See also, Mapping Dataset Properties.

Example Mappings
Some mapping functions must be in the same format, for example, when
Example A: Mapping one variable to another
Once the dataset source is mapped, we can map individual variables from the Target dataset. In this example, we’ll map the target variable “SITEID” to the source variable “SITE”.
- From the Target Dataset, select the Variable “SITEID”
- Open the Plugin properties tab and click Add Mapping Group from Dataset Mapper properties
- Enter the select Source Variable from the Source Type
- From the Source field add “SITE”.
When you run a conversion, the Variable in the Target dataset is populated with data from the source variable.

Example B: Concatenating PROJECT, SITEID, and SUBJECTI to derive the Unique Subject Identifier USUBJID
In this example we’ll use a function to concatenate these variables.
- Select the Variable USUBJID in the Target dataset
- From Dataset Mapper properties, Click Add Mapping Group
- For this Source Type, select Function
- Under Function, Click Add Function Group and and select the Function Name: Concatenate
- Click Add Parameter Group and fill in the following:
- Source Type: Source Variable
- Source: PROJECTI
- Click Add Parameter Group again and add:
- Source Type: String
- Source: -
- Click Add Parameter Group and add:
- Source Type: String
- Click Add Parameter Group and add:
- Click Add Parameter Group and add:
- Source: -
- Source Type: Source Variable
- Source: SITEID
- Source Type: Source Variable
- Source: SUBJETI
When you run a conversion, these three variables are concatenated into one in the Target dataset.
Example C: Converting a date string into ISO 8601 format
In this example the collected date (BRTHDTC_) is not in ISO 8601 format, you can use a function to map the string into the correct format.
- Select the Variable BRTHDTC in the Target dataset
- From Dataset Mapper properties, Click Add Mapping Group
- For this Source Type, select Function
- Under Function, Click Add Function Group and and select the Function Name: Convert date to ISO 8601
- Click Add Parameter Group and fill in the following:
- Source Type: Source Variable
- Source: BRTHDTC_
- Click Add Parameter Group again and fill in the following:
- Source Type: String
- Source: dd-MMM-yy
The string parameter must match the formatting of the source string.
The BRTHDTC variable is converted to the correct format when you run the conversion process.
Example D: Compute DY
In this example, the number of days since the study start date is calculated. The number of days is calculated by comparing two date variables in the source dataset, Reference Start Date (RFSTDTC) and Date of Collection (MBDAT). These Dates should be in ISO 8601 format for this example.
- Add a Variable in the Target dataset called Study Day Count
- From Dataset Mapper properties, Click Add Mapping Group
- For this Source Type, select Function
- Under Function, Select Compute DY
- Click Add Parameter Group and fill in the following:
- Source Type: Source Variable
- Source: RFSTDTC
- Click Add Parameter Group again and fill in the following:
- Source Type: Source Variable
- Source: MDBAT
Note: Both Source Variables must be in the same format, for example, date (2021-10-17) or datetime (2021-10-17T07:44). If they are not in the same format then you must use another function to change the formatting.
When the conversion is run, the Study Day Count column displays the number of days between the dates specified in the source.

Tutorial: Mapping Multiple Source Datasets
The following video shows an example of pulling data from two datasets (AE and AEPBASIC) into one dataset (AE_A01).
The video shows the typical workflow for working with dataset mapper, including the following:
- Viewing the source data
- Mapping individual variables from multiple sources (AETERM)
- Using Copy Mapping Group to extend the mapping to other datasets
- Converting date types to ISO 8601 format (AESTDTC)
- Running test conversions
- Viewing the converted data
Common Dataset Mapping Properties
The following properties are commonly used when mapping datasets:
Include Rows
Include Rows allows you to include rows of data depending on user-set conditions. For example to include rows where a variable has a specific value. Include Rows uses Conditions that affect the input if the Condition evaluates to True. You can specify more than one Condition. Conditions are logic operations and subsequent Conditions apply depending on the previous Condition and any logic operators.
The following example would include Medical History data where the MHPRESP variable is equal to “Yes”

Sort Output Rows
Sort Output Rows allows you to sort rows in the target dataset or output. For example, by sorting data by Unique Subject Identifier. You can add more than one Sort Key so that subsets of data are sorted.
