# Data mapping - cfxdm - dm:map

**dm:map:** This tag allows the user to manipulate or transform the columns and their values. 

Below are some of the operations you can perform using this tag.

* Copy the Column X along with its values as is and create a new Column Y
* Transform values from a Column to something else using 'functions' based on the user's requirement

**dm: map syntax:** 

* **dm:map from = '*****COLUMN\_X*****' & to = '*****COLUMN\_Y*****'**

OR

* **dm:map attr = '*****COLUMN\_Y' &*****&#x20;func&#x20;*****= "\<function-name>"  & \<argument syntax>***

Following two data CSV files are used to explain dm: map functionality

**Step 1**:&#x20;

Download the "[surveys.csv](https://macaw-amer.s3.amazonaws.com/rda/data/surveys.csv)" file to the local machine as shown below using a standard web browser.\
Download the [incidents.csv](https://macaw-amer.s3.amazonaws.com/rda/data/incidents.csv) file to the local machine as shown below using a standard web browser.

![](/files/-M_x4sZ7UOPhSWH-a2bm)

**Step 2**:  Upload (load) the above file into your RDA system as shown below.

* Using a web browser, connect to the RDA system \<https\://\<rda-ipaddress>:9998>
* Click on the CFXDX Python 3 icon from the main landing page of the RDA launcher (as shown below)&#x20;

![](/files/-M_x5Sc0C1-2QjcfMEsl)

* Launch AIOps studio using the RDA provided text field to start AIOps studio.

![](/files/-M_x5o_GvIsotp1GQDyi)

Select the files and upload them into the studio environment (as shown below).

![Select the two downloaded files locally to a folder.](/files/-M_x7oxqlBkQgx1qUKo0)

![Uploaded files into AIOps studio](/files/-M_x8rW8tx8leok1XWEq)

### **Example 1:** Clone the Column (copy)

This section explains two scenarios :\
1\. Creating a dataset from surveys.csv and incidents.csv files and create pipelines using AIOps studio functionality\
2\. Get the data from each dataset which includes some of the columns, **clone** the column X to column Y\
3\. Execute the pipeline.

### **Example 1a: Column names from surveys.csv file:**

* record\_id
* plot\_id
* length
* date etc

Step 1:  \
Create and add the following pipeline code/commands into the pipeline text field.

You can copy the below code into your pipeline and execute that in your AIOps environment.\
\&#xNAN;*`##### This pipeline loads surveys.csv file into AIOps studio stores the data loaded from ##### surveys.csv file into local dataset named 'cfxdm-map-clone-column'. Once`* \
*`##### the data is saved in 'cfxdm-map-clone-column' dataset, RDA functionality`* \
*`##### '@dm:map' is used to clone columns/names from the complete dataset that`* \
*`##### was read from csv file and rename those with user defined names as follows.`*\
\
*`@files:loadfile filename = "surveys.csv"`*\
*`--> @dm:save name = 'cfxdm-map-clone-column'`*\
*`--> @dm:map from = 'record_id' & to = 'Survey_record_id'`*\
*`--> @dm:map from = 'sex' & to = 'Gender'`*

Step 2: \
Verify the above pipeline code using the 'Verify' button and execute the pipeline (as shown below)

![Verify the pipeline code ](/files/-M_xEZ6CncuN2B-I_Ygt)

![Execute the pipeline](/files/-M_xF1KQks5gCiENP9aP)

Step 3:\
Once execution is completed, verify that the 'dm: map' cloned a column as expected (as shown below).

![After pipeline execution, dm: map columns are cloned to 'Gender', 'Survey\_record\_id'](/files/-M_xGAXk129uE_oIDHbT)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cloudfabrix.io/rda/rda-userguide/rda-aiops-studio/examples-jupyter/data-mapping-cfxdm-dm-map.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.