> For the complete documentation index, see [llms.txt](https://docs.cloudfabrix.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cloudfabrix.io/rda/rda-userguide/rda-aiops-studio/examples-jupyter/cfxdx-dm-concat.md).

# Data Mapping cfxdm - dm:concat

Merge or append two or more named datasets

**dm: concat:** This cfxdm function allows the user to merge two or more named datasets.

**dm:concat** syntax**:** 

* **names** (mandatory)**:** List of two or more named datasets, supports regex

{% hint style="info" %}
Please refer **to dm: save** and **dm: savedlist** functions on how to create and list named datasets.
{% endhint %}

Use **dm: savedlist** tag to list saved datasets

### Example 1:

Step 1: Create an empty **dm\_concat\_example\_1** using AIOps studio as shown in the below screenshot.

![Empty pipeline](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Mfdxr_hJ86fTyZuluKx%2F-MfePwY94A1JsyxP_Esl%2FScreen%20Shot%202021-07-27%20at%205.01.52%20PM.png?alt=media\&token=80afb6e4-5e74-429d-bec0-0bdb9ee938b3)

Step 2: Add the following pipeline code/commands into the above-created pipeline as shown in the below screenshot:

You can copy the below code into your pipeline and execute that in your environment.

\
*`###### Pipeline created two datasets simulating two alerting systems (PRTG, vrOPS) and`*\
*`###### generates data and saves into dataset.`*\
*`###### Pipeline uses dm:concat function to concatenate two datasets that are stored in RDA`*\
*`##### Pipeline also uses, dm:save and dm:savedlist`* \
\
*`####### PRTG Alerts Sections`* \
*`@dm:empty`* \
*`--> @dm:addrow prtg_alert_id = 'PRTG111122' & description = 'VM Outage' & priority = 'P0'`*\
 *`--> @dm:addrow prtg_alert_id = 'PRTG111123' & description = 'Increase CPU' & priority = 'P1'`* \
*`--> @dm:addrow prtg_alert_id = 'PRTG111124' & description = 'Disk resize' & priority = 'P1'`* \
*`--> @dm:addrow prtg_alert_id = 'PRTG111125' & description = 'App Install' & priority = 'P2'`* \
*`--> @dm:addrow prtg_alert_id = 'PRTG111126' & description = 'DB bounce' & priority = 'P0'`* \
*`--> @dm:save name = "prtg-alerts"`*\
\
*`####### vrOPS Alerts Sections`* \
*`--> @c:new-block`*\
*`--> @dm:empty`* \
*`--> @dm:addrow alert_id = 'vrOps22221' & description = 'Outage' & priority = 'P0'`* \
*`--> @dm:addrow alert_id = 'vrOps22222' & description = 'Increase CPU' & priority = 'P1'`* \
*`--> @dm:addrow alert_id = 'vrOps22223' & description = 'Disk resize' & priority = 'P1'`* \
*`--> @dm:addrow alert_id = 'vrOps22224' & description = 'App Install' & priority = 'P2'`* \
*`--> @dm:addrow alert_id = 'vrOps22225' & description = 'DB bounce' & priority = 'P0'`* \
*`--> @dm:save name = "vrops-alerts"`*\
\
*`--> @c:new-block`* \
*`--> @dm:concat names = 'prtg-alerts|vrops-alerts'`* \
*`--> dm:save name = 'consolidated-alerts'`*\
*`--> @c:new-block --> *dm:savedlist`*<br>

![Pipeline code added to RDA](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-MfeRSgxe32W120kvej7%2F-MfeSIUwmMW6QxJ-i6CT%2FScreen%20Shot%202021-07-27%20at%205.13.01%20PM.png?alt=media\&token=a173cbc6-ccd6-4e22-98a3-592a2c8c674c)

Step &#x33;**:** Click verify button to verify the pipeline. RDA will verify the pipeline without any errors (as shown below)

![Pipeline code verified ](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-MfeSXE4wfHXn2etwbs0%2F-MfeSx1UoV-xvIRVMrcb%2FScreen%20Shot%202021-07-27%20at%205.15.51%20PM.png?alt=media\&token=5dc750ca-0af1-4bad-a7d3-d93d9bcfdeae)

Step &#x35;**:** Click execute button to execute the pipeline. RDA will execute the pipeline without any errors (as shown below)

![Screenshot -1 ](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-MfeTORaWacar_yYmfgJ%2F-MfeTs3bXugDZzTL2zba%2FScreen%20Shot%202021-07-27%20at%205.19.55%20PM.png?alt=media\&token=a4bdbfa6-d949-46e5-ae76-a65116e750cc)

![Screenshot -2 (Execution of pipeline without any errors)](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-MfeTuwiMjVoLFh6t9my%2F-MfeUD3AvxI84o36XKjD%2FScreen%20Shot%202021-07-27%20at%205.21.25%20PM.png?alt=media\&token=61e20f85-feb9-4a4b-8c77-1d83ec084b70)

Step 6: Verify that the incidents-summary dataset is part of the dm: savedlist and dm:recall call as shown in the below screenshot.

![](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-MfeUMa3MAEbmdIkmpWQ%2F-MfeUuit2s4dWQEhr9Bd%2FScreen%20Shot%202021-07-27%20at%205.24.29%20PM.png?alt=media\&token=2abc8a3b-eddf-4e76-aa1a-d2c8b050ecf5)