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
Please refer to dm: save and dm: savedlist functions on how to create and list named datasets.
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.
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
Step 3: Click verify button to verify the pipeline. RDA will verify the pipeline without any errors (as shown below)
Step 5: Click execute button to execute the pipeline. RDA will execute the pipeline without any errors (as shown below)
Step 6: Verify that the incidents-summary dataset is part of the dm: savedlist and dm:recall call as shown in the below screenshot.
Last updated
