{"id":71200,"date":"2026-09-07T12:19:16","date_gmt":"2026-09-07T04:19:16","guid":{"rendered":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-admin\/dataset-merging\/"},"modified":"2026-09-23T15:37:51","modified_gmt":"2026-09-23T07:37:51","slug":"dataset-merging","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-explorer\/explorer-admin\/dataset-merging\/","title":{"rendered":"Dataset Merging"},"content":{"rendered":"\n

This article applies to IFS OI Explorer versions 26R1 (IFS Cloud release) and later. For more, see Release History<\/a>.<\/p>\n

The Dataset Merging page is used to create datasets by combining data from two existing Explorer datasets.<\/p>\n

The page is available under the Explorer Administration menu. Users must have the Create Dataset privilege to access the Dataset Merging page.<\/p>\n

Users with the required privilege can select columns from the source datasets, configure aliases, define join conditions, and preview the merged dataset.<\/p>\n

Opening Dataset Merging\u00a0<\/p>\n<\/h2>\n

\"\"<\/a><\/p>\n

1. Click the Explorer Administration icon in the navigation menu.<\/p>\n

2. Select Dataset Merging<\/strong>.<\/p>\n

3. You can use the search box to locate a merged dataset.<\/p>\n

4. Existing merged datasets are displayed in the list.<\/p>\n

5. Click Add<\/strong> Merged Dataset<\/strong> to create a new merged dataset.<\/p>\n

\n

Viewing, Editing, or Deleting a Merged Dataset<\/p>\n<\/h2>\n

\"\"<\/a><\/p>\n

1. Existing merged datasets are displayed in the list. Select a merged dataset from the list.\u00a0<\/p>\n

2. The configuration for the selected merged dataset is displayed in the Merged Dataset Details<\/strong> section. Review the existing configuration or make any required changes.<\/p>\n

3. Click Save<\/strong> to apply any changes.<\/p>\n

4. You can use the Delete<\/strong> option to remove the merged dataset.<\/p>\n

\n

Creating a Merged Dataset<\/h2>\n

The merged dataset configuration consists of the dataset name and description, together with the Merge Datasets, Join By, and Sort By sections, which are used to define how the source datasets are combined.<\/p>\n

This configuration automatically generates the required Dataset Query Language (DQL) query based on the selected options, removing the need to manually create DQL statements.\u00a0<\/p>\n

Read more: Dataset Query Language (DQL)<\/a><\/p>\n

To create a merged dataset, click Add Merged Dataset<\/strong>. The merged dataset configuration is then displayed.<\/p>\n

\"\"<\/a><\/p>\n

1. Enter a Name. The name must be unique and is used to identify the dataset in Explorer.<\/p>\n

2. You can add an optional description to provide additional information about the merged dataset.<\/p>\n

3. Under Merge Datasets<\/strong><\/a>, select a dataset from the left dataset selector.<\/p>\n

4. Select a dataset from the right dataset selector.<\/p>\n

5. Select the columns from the two datasets that should be included in the merged dataset.<\/p>\n

6. You can also provide aliases for columns to rename them or to resolve naming conflicts between datasets.<\/p>\n

7. Use Join By<\/strong><\/a> section to define the join conditions.<\/p>\n

8. The Sort By<\/strong><\/a> section can be used to define the order of the merged dataset results.<\/p>\n

9. Click Save<\/strong>.<\/p>\n

10. Click Preview<\/strong><\/a> to review the merged dataset results.<\/p>\n

Merge Datasets<\/h3>\n

The Merge Datasets<\/strong> section is used to select the two source datasets and determine which columns are included in the merged dataset.<\/p>\n

The selected datasets are displayed side-by-side and show the available columns for each dataset.<\/p>\n

Select the checkbox beside each column that should be included in the merged dataset.<\/p>\n

Aliases can be used to rename selected columns. This can be useful for improving readability or resolving duplicate column names between the selected datasets.<\/p>\n

Join By<\/h3>\n

The Join By<\/strong> section is used to define how records from the two datasets are combined.<\/p>\n

Select a column from each dataset and choose the join type that should be applied.<\/p>\n

The following join types are available:<\/p>\n

\"\"<\/a><\/p>\n

Note: When Cross Join is selected, the column selectors are disabled because no matching columns are required.<\/p>\n

Using Entity Metadata<\/h4>\n

Dataset Merging supports joining datasets using entity metadata. If a selected column has associated entity metadata available, the Metadata<\/strong> option can be selected from the dropdown.\u00a0 \u00a0\u00a0<\/p>\n

When Metadata option is selected, a metadata definition dropdown is displayed, allowing an entity metadata definition to be selected for the join condition.<\/p>\n

\"\"<\/a><\/p>\n

When entity metadata is selected on both sides of the join condition, the selected metadata definitions must use compatible data types. The following compatibility rules apply:<\/p>\n